re: how to add 10,000 records to new file with one field set equal to counter

[Jim Langston <jlangston@xxxxxxxxxxxxxxxx>]

I think a trigger on the file would serve you best.  Just change the
field to the record number on an add trigger.

Regards,

Jim Langston

From: "Stone, Joel" <StoneJ@GourmetAward.com>
Subject: how to add 10,000 records to new file with one field set equal to 
counter

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

- ------_=_NextPart_001_01BFAED1.9CFBAA80
Content-Type: text/plain;
        charset="ISO-8859-1"

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?


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