RE: [U2] Viaduct data transfer

2005-07-20 Thread Andrew Lakeland
The command string is simulating the keys you would enter if you were to do the same manually via the menus, this depends on the version of viaduct you are using as these changed over the years. 008 PRINT PCMCD:KEY /O /P ALT+FE:DOSPATH:CRUPLOAD.FILECR#CR1 2CROCRCRALT:ENDCMD: If you use the alt

RE: [U2] DATABASE write problem

2005-07-20 Thread Brian Leach
Anmol, Are both of the processes UniVerse processes, or is one of them an external process (script, executable etc.)? If the latter, some contention at the OS level is probably inevitable, with the other (non-UV) process having the file open. Whenever I have had that combination, I always use a

Re: [U2] UV Pre-printed forms

2005-07-20 Thread Ian Stuart
We use UNFORM, a great tool for designing forms and report layouts and integrates with email, pdf, postscript (via ghostscript) etc. Very affordable and runs on UNIX, Linux and Windows in a client/server setup Ian Stuart Cordes, Tom (contractor) wrote: TEST -Original Message-

RE: [U2] What is the opposite of FORM.LIST? (uv10)

2005-07-20 Thread Dave Walker
Depending on your basictype, you'd be wanting either READLIST or READSELECT. READLIST dyn.array.var [FROM list.num] {THEN statements [END] | ELSE statements [END]} Synonym READSELECT (BASICTYPE P only) -- Dave Walker 8..7 4(()) -::- -::-8.74 .74(())

RE: [U2] What is the opposite of FORM.LIST? (uv10)

2005-07-20 Thread Chuck Mongiovi
How about COPY-LIST? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Walker Sent: Wednesday, July 20, 2005 8:33 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] What is the opposite of FORM.LIST? (uv10) Depending on your basictype, you'd be

RE: [U2] What is the opposite of FORM.LIST? (uv10)

2005-07-20 Thread George Gallen
not basic, but Universe command. for instance.. I can enter FORM.LIST SOMEFILE SOMEITEM 3 record(s) selected to SELECT list #0. WHATCOMMAND SOMEFILE SOMEITEM ??? Do I use to write that select list back to a TYPE 30 file. SAVE-LIST filename Itemname only works with Type 1 and Type 19

RE: [U2] What is the opposite of FORM.LIST? (uv10)

2005-07-20 Thread George Gallen
that assumes the list is already in SAVEDLISTS I wanted to avoid that step (saving the list to SAVEDLISTS. ED VOC COPY.LIST 4 lines long. : P 0001: PQ 0002: HCOPYI FROM SAVEDLISTS TO I2,ENTER DESTINATION FILE 0003: H I3,ENTER LIST ID,ENTER LIST ID 0004: P and...It doesn't have an

Re: [U2] THE variable names

2005-07-20 Thread CWNoah2
Will, There is a very good use for REMOVE. Consider a cross-reference item (inherited, not built by current programmer) which has many thousands of keys and IDs. You could select the IDs and READNEXT or REMOVE to process. Either is far faster than FOR/NEXT and extract. I've seen a 40

RE: [U2] DATABASE write problem

2005-07-20 Thread Stevenson, Charles
A known cause of UV error 040019 (my guess for Anmol is Variation-on-the-Theme #2): When processA is holding the update lock on a record, and processB issues a WRITE to that record, then processB will wait for the lock for 20 minutes (non-configurable), then abort or take ON ERROR clause with

RE: [U2] THE variable names

2005-07-20 Thread Trevor Ockenden
Aaah! REMOVE or not to REMOVE. REMOVE has three other associated statements that make the set a very powerful and distinct statement set indeed. REMOVE has REVREMOVE and GETREM and SETREM. The only gotcha I fell into many years ago was upon seeing a statement that read... VAR = VAR I

Re: [U2] What is the opposite of FORM.LIST? (uv10)

2005-07-20 Thread FFT2001
In a message dated 7/20/2005 5:41:57 AM Pacific Daylight Time, writes: I tried using SAVE-LIST FILENAME ITEMNAME but it doesn't seem to work, the FILENAME in question is a type 30, and the help page says it needs to be a type 1 or 19. Is there a way to get this to work on a

Re: [U2] THE variable names

2005-07-20 Thread FFT2001
In a message dated 7/20/2005 6:40:38 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: You could select the IDs and READNEXT or REMOVE to process. Either is far faster than FOR/NEXT and extract. I've seen a 40 minute process reduced to 6 seconds (thanks Louis Nardozi) by changing to

Re: [U2] THE variable names

2005-07-20 Thread Allen Egerton
From: [EMAIL PROTECTED] I have yet to hear of a good, legitimate, use for REMOVE. Even after 30 or so posts on this topic ;) Consider associated multi-value arrays, perhaps for automobiles, shall we say? And for some reason, you need to look at each and every car. So, (coding from memory

Re: [U2] What is the opposite of FORM.LIST? (uv10)

2005-07-20 Thread Allen Egerton
From: George Gallen [EMAIL PROTECTED] Looks like I'll be making a VOC to do the save/copy, only problem is I need to put in all the accounts that I want to use it in. Consider a system VOCLIB with remote pointers to the items from the accounts that use them. That way if you have to tweak the

REMOVE - post 31 (was: RE: [U2] THE variable names)

2005-07-20 Thread Ross Morrissey
I'll jump in with a good, legitimate REMOVE usage. Most of what we hear about is something like: IF (LONG.DELIMITED.STRING[1,1] NE ) THEN LOOP REMOVE ELEMENT FROM LONG.DELIMITED.STRING SETTING MORE.DATA * Take Element-specific action WHILE

Re: [U2] DATABASE write problem

2005-07-20 Thread Key Ally
Jerry, I alwys like this sort of a protection against overwriting: 100BASE.ID = 'ZZZ' : '.' : DATE() : '.' : TIME() : '.' 101DONE = FALSE 102TIEBREAKER = 1 103LOOP 104 READU DUMMY FROM BASE.FILE, BASE.ID : TIEBREAKER LOCKED 105

Re: [U2] THE variable names

2005-07-20 Thread BNeylon
As long as you keep an open mind so that when the perfect situation for REMOVE comes up you will use it. :-) And if that perfect situation comes up, and if you allow yourself to code it, let us know. Bruce Bruce M Neylon Health Care Management Group [EMAIL PROTECTED] Sent by: [EMAIL

RE: [U2] What is the opposite of FORM.LIST? (uv10)

2005-07-20 Thread Stevenson, Charles
George, It should be there, but it ain't. But for this one it is easier to roll your own verb, than any other course of action. Just flesh out the following with error handling, @SYSTEM.RETURN.CODE, and maybe a get(arg.) for FROM [listno] for numbered select lists, @SYSTEM.RE CT CDS.BP

RE: [U2] DATABASE write problem

2005-07-20 Thread Kevin King
It can actually be done without the loop. Simply increment a unique sequential number for every record written so that the key has at least a time and the sequential number. If multiple records come through in the same second, they'll have a different sequential number and will still be unique.

Re: [U2] DATABASE write problem

2005-07-20 Thread Jerry Banker
The original poster said he didn't think using the time as the key would be the cause of the problem I just wanted to point out that it could unless he made sure that the key was indeed unique. - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org

Re: [U2] THE variable names

2005-07-20 Thread Anthony W. Youngman
In message [EMAIL PROTECTED], Trevor Ockenden [EMAIL PROTECTED] writes So Will please be open minded as to the need and merits of all statements as they are only unreadable to the uninitiated. Like, for example, Will's stating that REMOVE is obscure and WHILE READNEXT is clear ... I've been

Re: [U2] THE variable names

2005-07-20 Thread Moderator
All, Let's move this to u2-community. If you aren't subscribed to U2-Community, please visit http://listserver.u2ug.org/, enter your e-mail address, and 'browse all' lists to maintain your access. Post all future messages on this topic there. - Charles Barouch Moderator

[U2] Group By equiv?

2005-07-20 Thread Jeff Powell
Is there a UniQuery equivalent to the SQL GROUP BY clause? I've tried SSELECT with UNIQUE but it saves only one attribute and then I cannot subsequently list other attributes. UniData version 5.2 UniObjects for Java Web Servlet application. Regards. --- u2-users mailing list

RE: [U2] Group By equiv?

2005-07-20 Thread Kevin King
What are you trying to do exactly? What's the data look like and how do you want it presented? Usually you can do a BREAK.ON with ID.SUPP and DET.SUPP (alternatively (ID) and get summary reporting out of UniQuery. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

RE: [U2] THE variable names

2005-07-20 Thread Trevor Ockenden
Will wrote... I have yet to hear of a good, legitimate, use for REMOVE. OK! Good point Will. Try coding a routine like sdiff that you can find in some flavours of Unix in UVBasic with and without the REMOVE set of statements and see the difference it makes to the speed. This task was greatly

RE: [U2] Group By equiv?

2005-07-20 Thread Jeff Powell
Kevin, I have a file that has every product category attributes for: product line, product description (16,736 of these), major product group, major group description (133 of these). I want just the major group data from that without any duplicates. It going into a drop menu for the user to

[U2] Uvbackup to disk

2005-07-20 Thread Dan Fitzgerald
Is there an option to uvbackup (without the uvadm gui) to direct output to disk instead of tape? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Group By equiv?

2005-07-20 Thread Kevin King
Sounds like Prelude. You sure this information isn't normalized into some other file? Seems like an aweful lot of work to scan 16K+ records to fill a drop-down list. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Wednesday, July 20,

RE: [U2] Uvbackup to disk {Unclassified}

2005-07-20 Thread HENDERSON MIKE, MR
Yes, -t HELP uvbackup tells you all about the -t option: |-t Specifies the device to which to write backup | | data. device can be either a pathname or an entry | | in the DEVICE file. Use multiple -t options to | | specify up

Re: [U2] Uvbackup to disk

2005-07-20 Thread Dan Fitzgerald
Thanks, Dave. This is on AIX 5.2. Specifically, we have a solution that does an rsync from a remote backup server. But this is unaware of locks, updates, etc. I'd like to shoot an image of uvbackup to a spot on disk, then export that for the enterprise backup. Our greatest duty in this

RE: [U2] Uvbackup to disk {Unclassified}

2005-07-20 Thread Dan Fitzgerald
You would think... but, no. By device or pathname, it seems to want a tape drive. I set up an DEVICE item, but still to no avail. Yes, -t HELP uvbackup tells you all about the -t option: |-t Specifies the device to which to write backup | | data. device can

RE: [U2] Uvbackup to disk

2005-07-20 Thread Jay Falck
Dan, I use the following command to create .BAK files from uvbackup: uvbackup -f -b 1024 -l backup set label -s uvbackup.log -cmdfil files.cmdfil -notag backupset.bak Hope this helps, Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald