RE: [U2] @variable for add/delete flags

2005-12-19 Thread Ray Wurlod
Further, if the old record is "" and the new record isn't, it's an insert. If the new record is "" and the old record isn't, it's a delete. And if neither is "", it's an update. - Original Message - From: "Mark Eastwood" <[EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org Subject: RE:

[U2] UniData create file

2005-12-19 Thread Bill Haskett
Whew. I figured it out. The key was to create a DICT only file, then change the 1st attribute from "F" to "LF", then I can create the data files by: CREATE-FILE MULTIFILE PATCHES,BP 11,4 Sometimes life is good during these pesky conversions. :-) Bill --- u2-users mailing list u2-users@lis

Re: [U2] Small FootPrint MultiValue

2005-12-19 Thread Mark Johnson
Not for nothin' but whenever I install D3 on a box, it seems to take around 5 seconds. Noticably shorter than any MS office product. If that qualifies as a small footprint. My 1 cent. - Original Message - From: "Andy Pflueger" <[EMAIL PROTECTED]> To: Sent: Monday, December 19, 2005 11:32

[U2] UniData create file

2005-12-19 Thread Bill Haskett
I'm trying to create a UniData multi-level file (v7.1). I was able to create a multi-level directory by: 1) changing field# 1 of the (VOC) "BP" item to LD 2) CREATE.FILE MULTIDIR BP,CUSTOM I cannot yet create a multi-leveled hashed file by: 1) changing field#1 of the (VOC) "PATCHES" item to LF

Re: [U2] Using Esc

2005-12-19 Thread Mark Johnson
That is the one thing that is the most Jurrasic about MV systems, the INPUT statement. It's a shame that it needs so many home-grown methods that try to match with the language's IN or GET statements with the specific emulator's expressions of the characters being typed (and filtered). I wish the

RE: [U2] Rebuilding indexes on files on Unidata

2005-12-19 Thread colin.alfke
Sorry, no better idea on the internal structures of the index - just the obvious: 1. Was the index created on a different version of UniData or O/S? 2. Were the same attributes indexed/were the dictionaries the same? 3. Was the alternate key length any different? A list.index from before and afte

RE: [U2] UV: LIST.READU question

2005-12-19 Thread Anthony Dzikiewicz
Im not sure about the strings / list_readu. I would imagine that strings just filters our readable characters from the list_readu file itself not the output of list_readu (unless you are piping the output). I used to use strings on large (non text) error logs and grep for certain data. Sorry, but

[U2] Dataflo missing Workfile

2005-12-19 Thread DelMarRich (sent by Nabble.com)
A month ago the UPS on our UNIX box running Dataflo with Preview/Wintegrate went out. After repairing and coming back up, we noticed that users on port (UDTNO) 8 and 18 got the message "Cannot Update without WORKFILE - Inquiries Only" at the bottom of their screen. Is there a way to restore th

[U2] Rebuilding indexes on files on Unidata

2005-12-19 Thread Baakkonen, Rodney A (Rod) 46K
Over the weekend, I rebuild the indexes for our largest file for claim details. This file has about 41 million records in it. The directory for the dynamic file says it uses 35 gig of space. So it is a pretty good sized file. Prior to rebuilding the indexes, they were contained in 8 separate files

RE: [U2] @variable for add/delete flags

2005-12-19 Thread colin.alfke
With UniData we simply use the record_id from the trigger's subroutine parameters to read if the record already exists. Perhaps not the most efficient method - but it works reasonably well. Hth Colin >-Original Message- >From: Bill Haskett > >Does either of the U2 products have an '@' var

RE: [U2] Re: The Venerable Ken Wallis

2005-12-19 Thread colin.alfke
Absolutely. Feel free to substitute knowledge and experience for age in that definition. Besides - I have absolutely no idea how old you are ;-) Colin >-Original Message- >From: ken_wallis [SNIP] >> "Commanding respect by virtue of age, dignity, character, or >> position." >> >> I see

RE: [U2] @variable for add/delete flags

2005-12-19 Thread Mark Eastwood
If I understand the question correctly; In UniVerse, one of the parameters passed into the trigger subroutine is "event" (i.e. Update, Delete, Insert). Mark -Original Message- Does either of the U2 products have an '@' variable to identify if the @RECORD read into a trigger program is a

Re: [U2] Re: The Venerable Ken Wallis

2005-12-19 Thread [EMAIL PROTECTED]
Tom Pellitieri wrote: > Ken Wallis <[EMAIL PROTECTED]> wrote > > > colin alfke wrote: > > > > > Here is a snip of a post the venerable Ken Wallis made > > > a while back explaining how a program is found. > > > > I'm not convinced that I like being referred to as > 'venerable' ;^) > > The Americ

RE: [U2] Using Esc

2005-12-19 Thread Brutzman, Bill
The code for my UniBasic compiled program ( called PRJ ) does the following... I notice that there is a KEYEDIT command in the UniBasic manual. - >PRJ ^[ char(210) char(201) That is, the Pi character followed by the upper left dou

Re: [U2] Using Win XP/Pro as a 'server' for Universe

2005-12-19 Thread u2ug
Posted on behalf of Don Kibbey <[EMAIL PROTECTED]> It can be made to work. You will find that you will sometimes run into issues with the 10 connection limit on the tcp/ip stack. If you customer is also going to use said XP machine as a regular workstation they will also have performance pro

RE: [U2] UV: LIST.READU question

2005-12-19 Thread Hennessey, Mark F.
Anthony: We see that from time to time. However, only when we issue LIST.READU EVERY. It is a deadlock. Yes, as was pointed out by another poster as well (BobW), we were running with the EVERY option. And thanks for telling me how the entry got there. Using the unix 'strings' command, I

[U2] @variable for add/delete flags

2005-12-19 Thread Bill Haskett
Does either of the U2 products have an '@' variable to identify if the @RECORD read into a trigger program is a new record or a record being deleted? Thanks Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Using Win XP/Pro as a 'server' for Universe

2005-12-19 Thread Results
Joe, I'm running UniVerse PE on an XP Pro laptop, using NTFS successfully. I have never run this configfuration in production. All my users are admins. I have had problems with vmuvadm.exe on this machine, but I think that's because it's a pseudo-dual chip system (two cpus on one chip, as I

RE: [U2] Using Win XP/Pro as a 'server' for Universe

2005-12-19 Thread Robert.Porter2
Just be aware... for many of the built in services (IIS, file sharing, etc.) there is a 10 concurrent connection limitation. I also believe it is a licensing issue. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UV: LIST.READU question

2005-12-19 Thread Anthony Dzikiewicz
We see that from time to time. However, only when we issue LIST.READU EVERY. It is a deadlock. You have to find out who the two users are. In your example, it looks like a phantom or batch process and a user on a terminal. You have to pick one of the two to kill in order to free up the lock.

Re: [U2] Using Esc

2005-12-19 Thread Results
Bill, Try CRT'ing the ASCII value of ANS to see what Esc is reporting as on this system. I have see 27 (typical), 251, and even 21 on some other terminal emulators. - Chuck The following code does not behave as intended. Esc = char(251) begin case case Ans = '' ; null

RE: [U2] Using Esc

2005-12-19 Thread Allen E. Elwood
Yup, esc is definitely char 27. Allen E. Elwood www.tortillafc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Harry Hambrick Sent: Monday, December 19, 2005 10:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Using Esc An escape is char(27) isn't

[U2] Using Win XP/Pro as a 'server' for Universe

2005-12-19 Thread Joe Walter
No doubt this topic has been discussed before, I may have even brought it up in the past myself. But, my memory seems faded lately so I'm gonna throw it out there again. I have a small customer with a 7 user universe license that wants to dump the NT4 server they are currently running it on and tr

Re: [U2] Using Esc

2005-12-19 Thread Leroy Dreyfuss
Try using CHAR(27), which is the escape key by default. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases [cid:_2_103D8C40103D89EC006797D3872570DC] Information Management Software Tel: 303-773-7783 Fax: 30

RE: [U2] Using Esc

2005-12-19 Thread Harry Hambrick
An escape is char(27) isn't it? A char(251) is a start buffer. Harry Hambrick Geac Public Safety -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Monday, December 19, 2005 1:23 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Usin

RE: [U2] UV: LIST.READU question

2005-12-19 Thread Bob Woodward
We look for this all the time. Usually, though, it only shows up if we use the command "LIST.READU EVERY". This is how we tell if someone is sitting in and Entry/Update screen instead of the Inquiry screen. We then go smack the fingers of the "Owner" ID with a ruler. (I like that part!) BobW

[U2] Using Esc

2005-12-19 Thread Brutzman, Bill
I am trying to add functionality for the Escape Key in UniBasic program for end-users to edit record data with Dynamic Connect and UV. Terminal emulation is AddsVP moving to VT-100. The following code does not behave as intended. Esc = char(251) begin case case Ans = '' ; null

[U2] UV: LIST.READU question

2005-12-19 Thread Hennessey, Mark F.
We've come across some output from LIST.READU that appears to not be documented. After the usual (and documented :) Group and record locks, we saw: 0037: Active File Waiters: Owner Waiter 0038: Device Inode Userno Userno 0039:22595385493 44841 13 So, it a

Re: [U2] Small FootPrint MultiValue

2005-12-19 Thread Andy Pflueger
On 12/19/05, Brutzman, Bill <[EMAIL PROTECTED]> wrote: > Aside from U2 Personal Edition, are there any multi-value products like say > IBM's CloudScape that do multi-value? > There's always the open-sourced solution which does have a commercial version. Details found at www.openqm.com courtesy of

Re: [U2] Small FootPrint MultiValue

2005-12-19 Thread Results
Bill, I assume you mean 'free to use' multi-value? Look at OpenQM, Winter, Maverick, Bart. For fee, look at OI, jBASE, QM, mvBASE, D3, Reality, UniVision, lots of choices. If you meant 'from IBM', Datastage is considered a separate product and it's built on U2 technology. Brutzman, Bill w

Re: [U2] Small FootPrint MultiValue

2005-12-19 Thread Dawn Wolthuis
On 12/19/05, Brutzman, Bill <[EMAIL PROTECTED]> wrote: > > Aside from U2 Personal Edition, are there any multi-value products like > say > IBM's CloudScape that do multi-value? Are you asking only about IBM products or are you asking for all databases that permit multivalues? I don't know the an

RE: [U2] Small FootPrint MultiValue

2005-12-19 Thread Dave Walker
You might like to check out openqm or MaVerick. http://www.openqm.com http://www.maverick-dbms.org/ Regards, -- Dave Walker "Did you ever walk into a room and forget why you walked in? I think that's how dogs spend their lives." Sue Murphy > -Original Message- > From: [EMAIL PROTECTED]

Re: [U2] Small FootPrint MultiValue

2005-12-19 Thread Martin Phillips
Hi Bill, > Aside from U2 Personal Edition, are there any multi-value products like say > IBM's CloudScape that do multi-value? Take a look at our web site at www.openqm.com. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-u

[U2] Testing

2005-12-19 Thread Janke, Mark
Just testing - I haven't received any messages for a while. Mark --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] Small FootPrint MultiValue

2005-12-19 Thread Brutzman, Bill
Aside from U2 Personal Edition, are there any multi-value products like say IBM's CloudScape that do multi-value? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] global catdir question - security hole

2005-12-19 Thread john reid
Didnt mean to stir the 'stuff'. I do have my answer. Also, I believe we did try to give a privileged user rw and everyone else 'read' for catdir. Thankfully we tried it on our development machine, because the outcome was like a scene from 'war of the worlds'. j On 12/19/05, Hona, David S <[EMA

[U2] Re: The Venerable Ken Wallis

2005-12-19 Thread TPellitieri
Ken Wallis <[EMAIL PROTECTED]> wrote on Sat, 17 Dec 2005 16:21:34 +1100 RE: [U2] LOGTO question... > > colin alfke wrote: > > > Here is a snip of a post the venerable Ken Wallis made a while > > back explaining how a program is found. > > I'm not convinced that I like being referred to as 'venerab

RE: [U2] global catdir question - security hole

2005-12-19 Thread Hona, David S
Martin raised a good point. However, the problem is not the APIs itself (all the APIs have this weakness), but how the U2 environment relies on the underlying OS for user authentication and security. This is the fundamental basic flaw of the U2 environment. Improve this and then you can build a be

Re: [U2] global catdir question - security hole

2005-12-19 Thread Martin Phillips
My last word on this (at least for now!) > You can lock down Universe so that a UniObjects developer cannot modify or > delete files. If someone with a genuine commercially sensistive environment would like to give me a valid user name and password for uniObjects access to their system, I wil