[U2] RE: UCI connection problems ('SQLConnect failed' / 'Failure to login as remote user')

2004-12-13 Thread LeRoi Keiller
I forgot to mention that this problem occurred after the client upgraded to UniVerse 10.1.4 (on AIX) - it was working prior to this. UCI is known to work on this release. File permissions all look okay. Finally, I meant 'ucisample' (not 'samplesuci'). :o) -Original Message- From:

[U2] [UV / UNIX] - Automatically retrieving Exchange Rate from the Internet

2004-12-13 Thread Mike Farrant
All, I have HP-UX B.11.11 and Universe 9.6.1.6 I need to update my app. with live (daily) currency exchange rate information. I used to do this by extracting information from a text base file posted to the internet by the IMF but it appears that they have now stopped doing this?? It struck me

RE: [U2] [UV / UNIX] - Automatically retrieving Exchange Rate from the Internet

2004-12-13 Thread Chuck Mongiovi
I need to update my app. with live (daily) currency exchange rate information. I used to do this by extracting information from a text base file posted to the internet by the IMF but it appears that they have now stopped doing this?? It struck me at the time that this was a Try using lynx

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Allen Egerton
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 13, 2004 10:33 AM Subject: [U2] LOOP or GOTO on READNEXT My intent is not to start a religious discussion about GO or GOTOs because I see that method all over the place and regardless of why, who or whatever, my question is,

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread MBTPublish
In a message dated 13/12/2004 15:49:31 GMT Standard Time, [EMAIL PROTECTED] writes: I've seen 2 ways to read a client key, change the length to 6 digits, then write it back out, delete the old one and move on: EXAMPLE 1 of 2: !(FIXEMPNO) - Fix the employee number length open '','CUSTEMP' to

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Rick Ramsey
example 2 does not test DONE - why not READNEXT K ELSE EXIT cannot prove it, but I suspect both of these paragraphs would function identically at the object-code level. Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday,

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Mats Carlid
If You correct the second example so the loop stops when the list is exhausted it will be the same. They are very likely to compile to exactly the same pseudo-code. And even if they don't the body of the loop is so heavy, having a write and a read and a delete in it, so You've no

Re: [U2] Capturing screen output in Unidata Enviornment

2004-12-13 Thread Lee Beel
Good Morning Frank, The simple answer is to use your terminal emulator. For a more complex Paragraph use the COMO verb. HTH. Lee [EMAIL PROTECTED] 12/13/04 07:53AM Good Morning All: I would like your help. I want to capture the screen output from a VOC Paragraph. But I want to know if

RE: [U2] Capturing screen output in Unidata Environment

2004-12-13 Thread Allen E. Elwood
Hi Frank, All of the terminal emulators that I have used allow mouse selecting of the text and then you click on EDIT/COPY or Ctrl-Insert shortcut to copy. Then just paste it into your word processor. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of

RE: [U2] Capturing screen output in Unidata Enviornment

2004-12-13 Thread Kevin King
Check out COMO. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bright, Frank Sent: Monday, December 13, 2004 8:54 AM To: U2-Users Group (E-mail) Subject: [U2] Capturing screen output in Unidata Enviornment Good Morning All: I would like your help. I

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread karlp
quote who=Rick Ramsey example 2 does not test DONE - why not READNEXT K ELSE EXIT You are quite right. I forgot putting that line in. until DONE do . . . cannot prove it, but I suspect both of these paragraphs would function identically at the object-code level. Rick -Original

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Allen E. Elwood
Hi Karl, Thank you for asking that question, 'cause funny as it sounds I never thought to do a speed test on this construct. I didn't include the delete statement because what you really wanted to test was the LOOP/REPEAT vs. the GO construct. Guess what? After doing four consecutive runs and

Re: [U2] Capturing screen output in Unidata Enviornment

2004-12-13 Thread Carole A Cafasso
You can type 'COMO ON some.name' before you execute the paragraph. This will create an entry in _PH_ called O_some.name, which you can then view through the editor. After you execute the paragraph, type 'COMO OFF'. If you are executing the paragraph in PHANTOM mode, include these commands in

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread karlp
I'm not sure of the BASIC SELECT. I've always used it and don't remember ever seeing any adverse affects therefrom. As for the safety option. It might apply somewhere else, but not in this little example. The file contained only about 80 items and a list showed no duplicates either before or

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread karlp
quote who=Allen Egerton Loops are loops, they're executed internally with jumps and skips... The LOOP WHILE construct is for the programmer, not for the runtime machine. You really want faster? Create a new file sized appropriately, read the rec from original file, modify the key, write

RE: [U2] Capturing screen output in Unidata Enviornment

2004-12-13 Thread Bright, Frank
Thanks All! I appreciate the responses. Colin's was the best as that the output was not displayed on the screen at all and you can save the captured output in a file. Thanks! Frank [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of

RE: [U2] Capturing screen output in Unidata Enviornment

2004-12-13 Thread Alfke, Colin
I usually just use the tools on my terminal emulator to do this. Otherwise my best suggestion is to write a program that executes the paragraph and use the capturing/returning to get the data. Does that help? Colin -Original Message- From: Bright, Frank Good Morning All: I would like

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Richard Brown
Just checking that you understand the problem with either of these methods. If the key length is already 6 digits then you will end up deleting the record. Richard - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 13, 2004 10:33 AM Subject: [U2]

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Mark Johnson
To further increase your speed with the file copy method use the Overwrite option (O when writing the data back to the cleared desired file from the temp file. This prevents the COPY command from seeing if the record exists and offering up the message. Technically if any target file is cleared,

[U2] Capturing screen output in Unidata Enviornment

2004-12-13 Thread Bright, Frank
Good Morning All: I would like your help. I want to capture the screen output from a VOC Paragraph. But I want to know if there is a command line command that would allow me to do this? I do not want to edit the paragraph. Thanks in advance! Frank [EMAIL PROTECTED]

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread karlp
quote who=[EMAIL PROTECTED] In a message dated 13/12/2004 15:49:31 GMT Standard Time, [EMAIL PROTECTED] writes: I've seen 2 ways to read a client key, change the length to 6 digits, then write it back out, delete the old one and move on: EXAMPLE 1 of 2: !(FIXEMPNO) - Fix the employee

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Bob Witney
Since you have the 2 pieces of code wouldn't the best approach be to benchmark it on the system which is going to run it. Or am I just getting old remembering when we needed to benchmark... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Mark Johnson
I agree. Be careful to not trip over a record written in later frames. Although WRITE after DELETE prevents the problem. I have an observed question. Is there any MV flavor that requires the null expression for DICT with opening the DATA level of a file. I stopped using that unnecessary code over

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Mark Johnson
Sort of like deleting MV's backwards in an attribute to not miss any. Been there as well. - Original Message - From: Dean Fox [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 13, 2004 2:04 PM Subject: RE: [U2] LOOP or GOTO on READNEXT Your understanding of the BASIC

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Allen E. Elwood
My understanding of the hashed concept is that once the group is calculated based on normalizing the ID and dividing by the modulo, a binary search occurs through the sorted ID's within the group to locate the real record id. Therefore a collision could only occur if truncation of an ID created

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread karlp
quote who=Dean Fox Your understanding of the BASIC select is correct. It starts in group one and works it's way down. In my early years of PICK programming I learned this the hard way. As this user hasn't yet seen adverse effects is luck vs. design. Okay, Bait taken. I just ran 2 programs.

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Allen E. Elwood
hmmm..goto wins, but why is your system only doing less than a million loops per second? The slowest I got on my PC was 13 million loops per second, and the fastest was 15.3 MLPS. Also, do you have users actually processing? My system is for me only and therefore is more consistent when

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Allen Egerton
On Mon, 13 Dec 2004 11:07:38 -0700 (MST), you wrote: snip Why does creating a new file make it faster? Couple reasons. Mostly because you're not deleting the original, which means fewer disk accesses. Remember that until the file's reclaimed, a delete is actually a mark as deleted, not a

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Mark Johnson
UD supports LOOP WHILE READNEXT ID DO D3 Supports LOOP READNEXT ID ELSE EXIT UNTIL 0 DO I don't recall what UV supports but it does have a streamlined version without needing the tired EOF=0 or DONE=0 scenarios. My 1 cent. - Original Message - From: Dave Schexnayder [EMAIL PROTECTED]

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread astarte00
Oh please God no -- Debster -- Original message -- On Mon, 13 Dec 2004 11:07:38 -0700 (MST), you wrote: Why does creating a new file make it faster? Couple reasons. Mostly because you're not deleting the original, which means fewer disk accesses. Remember

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Richard Brown
What you may be missing is how to selects differ. The 'EXECUTE SELECT' selects the complete file before processing starts. The 'SELECT file.var' selects one group at a time and processes that group. If a Key changes it may get written to a different group. If that group is after the original

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Derek Falkner
Karl, I am on thin ice here but, so far, nobody has stepped in with a better explanation, so I'll give it a try. Your first SELECT creates a list of items called the active select list. It takes a little while to construct as it reads the entire file in the process. The select list can then be

Re: [U2] RE: UCI connection problems ('SQLConnect failed' / 'Failure tologin as remote user')

2004-12-13 Thread Ray Wurlod
Have you destroyed a preliminary script as part of the upgrade? One that does a SET.REMOTE.ID? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

[U2] FW: unidata performance, default shell, udt.exe

2004-12-13 Thread Clark Dave
Generally paging through the input boxes and server side processing (assume selecting?) -- Date: Fri, 10 Dec 2004 12:27:08 -0600 From: DAVID WOLVERTON [EMAIL PROTECTED] Subject: RE: [U2] unidata performance, default shell, udt.exe Just curious - What aspect of the

[U2] LOOP or GOTO on READNEXT

2004-12-13 Thread karlp
I've seen 2 ways to read a client key, change the length to 6 digits, then write it back out, delete the old one and move on: EXAMPLE 1 of 2: !(FIXEMPNO) - Fix the employee number length open '','CUSTEMP' to CF else stopm 'Not' select CF 10: readnext K else stop read REC from

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Derek Falkner
Karl, I cannot speak to the issue of speed but I am concerned about the safety of either process; I believe you may end up with missing employees! I believe the BASIC SELECT sets a pointer at the start of group 1 and steps it through each item in that group before moving on to group 2. What

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Dave Schexnayder
Karl, You probably already know this, but the second example will never terminate. I believe you intended to include a LOOP WHILE DONE = 0 DO or LOOP UNTIL DONE DO but the code does not include that necessary piece. As to actual code produced, I do not know. However, I would recommend the

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Mark Johnson
Be careful of consecutive speed tests. With memory caching and virtual memory, the second process benefits from the first process loading and/or leaving data in memory. That may invalidate your victory if the second test won. My 1 cent. P.S. The GOTO Holy war will never end until it's removed

RE: [U2] [UV / UNIX] - Automatically retrieving Exchange Rate from the Internet

2004-12-13 Thread Adrian Matthews
We source ours directly from Reuters but that is likely to be a bit expensive for your needs. www.xe.com provides a free daily email of currency exchange rates, you could write an app to load that or parse it from their web-site. As long as you don't redistribute the data you should be legal as

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Dean Fox
Your understanding of the BASIC select is correct. It starts in group one and works it's way down. In my early years of PICK programming I learned this the hard way. As this user hasn't yet seen adverse effects is luck vs. design. Probably because of the a change to the least significant

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Craig Bennett
UPDATE filename SET @ID = EVAL FMT(@ID,'R%6'); Poetry, Poetry. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Mark Johnson
Fair enough. My earlier speed tests (circa R80 and MCD) were much longer and the virtual memory did its job and invalidated the tests. Nowadays we're splitting the atom so finely that 1/13,000,000 of a second is just barely longer than 1/14,000,000. Speaking of splitting, didja hear of the guy

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Allen E. Elwood
Hi Mark! No, I don't suspect that the GOTO holy war will ever end. It will just LOOP/REPEAT forever!! LOLsorry I really cracked myself up on that one. Yes, when reading and writing records to a file, the O/S will eventually load the entire file into main memory if there is enough room.

RE: [U2] Capturing screen output in Unidata Enviornment

2004-12-13 Thread Robert Paterson
snip I would like your help. I want to capture the screen output from a VOC Paragraph. But I want to know if there is a command line command that would allow me to do this? I do not want to edit the paragraph. /snip Sounds like a COMO would be useful? Just do the following: COMO ON

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread Allen E. Elwood
I pretty sure that the first SELECT form is fastest, *when* you intend to process the entire file. It's only when you will want instant access, and may want to bail out on a condition that the BASIC SELECT is used. So that you can create LIST type access statements, where you can hit Q to end

Re: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread karlp
quote who=Mark Johnson I agree. Be careful to not trip over a record written in later frames. Although WRITE after DELETE prevents the problem. I have an observed question. Is there any MV flavor that requires the null expression for DICT with opening the DATA level of a file. I stopped using

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread karlp
quote who=Bob Witney Since you have the 2 pieces of code wouldn't the best approach be to benchmark it on the system which is going to run it. Or am I just getting old remembering when we needed to benchmark... BenchmarK? We can do that? You must live in a dream world... I guess I

RE: [U2] Capturing screen output in Unidata Enviornment

2004-12-13 Thread glenn . herbert
Assuming you are on universe, check out the DIVERT.OUT command -Original Message- From: Bright, Frank [mailto:[EMAIL PROTECTED] Sent: Monday, December 13, 2004 10:54 AM To: U2-Users Group (E-mail) Subject: [U2] Capturing screen output in Unidata Enviornment Good Morning All: I

RE: [U2] LOOP or GOTO on READNEXT

2004-12-13 Thread karlp
Your explanation finally sunk in. Thanks to the others who tried. My file was static with no updating possible, or at least likely. That would show the same items regardless of the select methodology. That's one lesson I've been lucky not to have learned the hard way. Thanks, Karl quote

[U2] How to batch SELECT ... TOXML

2004-12-13 Thread Stuart . Boydell
I am sending XML from UniVerse to a webserver using callHttp. Currently we're on UV10.0.7 and won't be upgrading to a version of UV with XMLExecute() any time soon. The current technique is to EXECUTE 'LIST CUSTOMERS ... TOXML' CAPTURING postData. This works fine for relatively small amounts of

RE: [U2] How to batch SELECT ... TOXML

2004-12-13 Thread Allen E. Elwood
I had to create a 'break.my.list' to limit the amount of HUGE files that were being downloaded to an excel spreadsheet so that we could finish selling our company to Moen Faucet so they could close us down. Fun eh? Anyway, this is what I used to break up the huge lists so I could process files