Re: [U2] Strange happening...
I tend to use: SELECT FILENAME EOF = @FALSE LOOP READNEXT ID ELSE EOF = @TRUE UNTIL EOF DO CODE CODE CODE with GOSUB CODE CODE REPEAT The advantage here is that it allows you to bail out of the loop of you want to by setting EOF David -- From: George Gallen ggal...@wyanokegroup.com Sent: Monday, March 02, 2009 6:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Strange happening... It shouldn't, at least not to a empty ID because the condition test is on the READNEXT, not the ID. However, it will pass an empty ID to the coding, which could be worse, if there aren't constraint checks on the ID. George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Eric Armstrong Sent: Monday, March 02, 2009 11:28 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Strange happening... Allen, Regarding your loop structure below. What happens if the ID is empty string? Won't it bail out before all the ids are read! Eric Armstrong Lobel Financial IT Dept -Original Message- From: Allen Egerton [mailto:aeger...@pobox.com] Sent: Friday, February 27, 2009 8:37 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Strange happening... As for the loop structure, I tend to like this: SELECT FILENAME LOOP WHILE READNEXT ID CODE CODE CODE with GOSUB CODE CODE REPEAT It's clean, it's concise, it's easy to read... And I wish I could remember who taught me that you could combine the LOOP and READNEXT in that manner... -- Allen Egerton aegerton at pobox dot com PGP Key ID 0x8EA57261 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Speeding up processing through large dynamic table
If the array IN.TAB is only attributed, with say the customer number description with pipe delimited you can use REMOVE: LOOP REMOVE IN.LINE FROM IN.TAB SETTING MORE UNTIL IN.LINE = DO CUST.NUM = FIELD(IN.LINE,|,1) CUST.DESC = FIELD(IN.LINE,|,2) REPEAT -- From: George Gallen [EMAIL PROTECTED] Sent: Monday, November 17, 2008 7:05 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Speeding up processing through large dynamic table What if you eliminated the SWAP and changed: CUST.NUM = IN.LINE1,1 CUST.DESC = IN.LINE1,2 How long does it take? George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Laansma Sent: Monday, November 17, 2008 1:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Speeding up processing through large dynamic table Is there a way to speed up spinning through a very large dynamic table? Here is a sample of my program: A11 = DCOUNT(IN.TAB,@AM) FOR A1 = 1 TO A11 IN.LINE = IN.TABA1 SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE1 CUST.DESC = IN.LINE2 NEXT A1 A11 is 85,000+ and as this loop goes on, this thing get really slow. Any tips on speeding this up? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] File pointer question
Is it possible some other program has the file open in the other directory and its sharing the file handle? Either a COMMON issue or the rotating file pool? David -- From: T Stokes [EMAIL PROTECTED] Sent: Wednesday, June 11, 2008 11:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] File pointer question I have a file that is a F pointer in the VOC yet when a BASIC STATUS is ran on the file it points to a file in another account. Have not been able to locate the reason for this. I am sure it is something simple. The VOC entry look like this F FILENAME D_FILENAME The results from STATUS looks like this D:\directory other than the directory I am current located\FILENAME -- View this message in context: http://www.nabble.com/File-pointer-question-tp17788496p17788496.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] version control
We use Subversion with a Universe based system. The one piece of advice I would give is to split up the program files or xxPROCESS into logical SVN projects as we found that with a PROGS file of 2500+ programs it would take quite some time to update/commit etc. In the end we also wrote our own mechanism to deploy from SVN a branch out and compile the programs. Another product we use as we have a team of developers all working on similar code is a program called WinMerge which allows easy side by side comparison of programs. David - Original Message - From: David Beahm [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, April 16, 2008 9:22 PM Subject: [U2] version control We are looking to add our UniData/SBClient environment to Subversion, and wanted to get advice from anyone who has done something similar (CVS, etc.) Searching through past posts, I found Brian Leach's note about generating DICT items from scripts, which I quite like; I suspect there are more ideas like that around. First, however, we need to come up with a suitable repository structure. We have a number of live, proto, and development accounts on one box (HP-UX). We have some universally shared directory files, but most files are unique to each account. To begin with, we are wondering whether it would be best to have individual repositories for each account, or whether there should be one repository with relative paths for each account, or whether each account should be a different branch, etc. Suggestions welcome, however we are want to standardize on one solution -- Subversion. Thanks, David Beahm --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/