RE: Re[2]: how to add 10,000 records to new file with one field

If you didn't require FIELDA == RRN, you could use (I think)
INSERT INTO lib/file (FIELDA) VALUES (MAX(FIELDA) + 1)
on a trigger.

On other SQL systems I've used, tables can have an "auto incrementing"
attribute to generate a sequential numeric key.

Loyd

-----Original Message-----
From: eric.delong@pmsi-services.com
[mailto:eric.delong@pmsi-services.com]
Sent: Tuesday, April 25, 2000 3:17 PM
To: MIDRANGE-L@midrange.com
Subject: Re[2]: how to add 10,000 records to new file with one field 



     That will work, provided the trigger fires *AFTER *INSERT. Beware 
     RGZPFM if you delete any records as your RRN then would not match 
     fielda.  
     
     However, SQL works very well too, if the file is already populated 
     with data......
     
     UPDATE lib/file f 
        SET fielda=rrn(f)
     
     
     
     hth
     eric.delong@pmsi-services.com


______________________________ Reply Separator
_________________________________
Subject: re: how to add 10,000 records to new file with one field set
Author:  <MIDRANGE-L@midrange.com> at INET_WACO
Date:    4/25/00 11:05 AM


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


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