Re: [U2] Strange happening...

2009-03-02 Thread David Beaty

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

2008-11-17 Thread David Beaty
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

2008-06-12 Thread David Beaty
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

2008-04-16 Thread David Beaty
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/