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

Actually the trigger has to be *before *insert if you want to change the
value of a field and the allow repeated change has to be *yes.

> -----Original Message-----
> From: eric.delong@pmsi-services.com [SMTP:eric.delong@pmsi-services.com]
> Sent: Tuesday, April 25, 2000 2: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
+---