Re: Suggestions

What we do here, is make one unique id(7963535) and use that record the 
placeholder of your current unique id number.  Usually we have at least 
one date field, so use the date field to hold the next unique id number, 
and make the record that holds the unique id number have a unique id of 
7963535 or something like that.

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
Tel: 709-576-8132
Email: rpower@xxxxxxxxxx
Website: http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill




"Douglas W. Palme" <dpalme@xxxxxxxxxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
09/03/2005 04:27 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Suggestions






I have a physical file that will hold gas type information, but one of the 

fields needs to be an integer id field.  My experience with other db 
formats 
is that I could set that field to auto generate so that as each record is 
written it will increment the count by 1.  we will be using this for cross 

referencing to some other files and must be unique.

I know I can read through the file and increment a counter, but that seems 

to have a huge overhead, not to mention that as time goes on, it'll take 
longer and longer to calculate.

Does anyone have a viable suggestion on how to accomplish this? 

Douglas

-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.