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

The easiest way to increment by 1 with RPG I've ever found is to use the 
special word "PAGE" which auto increments by 1 every time it's used.  It 
isn't just for printing.  It'd be a 5 line program, maybe 6 lines?

_______________________
Booth Martin
boothm@earth.goddard.edu
http://www.spy.net/~booth
_______________________




"Stone, Joel" <StoneJ@GourmetAward.com>
Sent by: owner-midrange-l@midrange.com
04/25/2000 10:50 AM
Please respond to MIDRANGE-L

 
        To:     "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com>
        cc: 
        Subject:        how to add 10,000 records to new file with one field 
set equal to counter

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
+---