Re: how to add 10,000 records to new file with one field setequal tocounter

["David Morris" <dmorris@xxxxxxxxxxxxx>]

J. Stone,

If you have the C compiler, there is an SQL function that will generate a 
sequence in 
the SQL programmers guide.  If you do not have the C compiler, I could send you 
an 
RPGIV version.  If this is a one time shot, I would write a program or do two 
passes.  I 
also don't understand why you would want to do this, if you want a unique key, 
I would 
retrieve an external sequence, or a time stamp.

David Morris

>>> StoneJ@GourmetAward.com 04/25/00 08:50AM >>>
Is there a simple way to add 10,000 records to a new file such that one
field in the record is a counter as follows:

record#         fielda  
                contains
1               1
2               2
3               3
4               4
5               5

etc.


Can Query/400 do this?  Can SQL do this?  Or must I write an RPG pgm?

Thanks!

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---