Re: Re[4]: how to add 10,000 records to new file with one fi

The method we have used in the past is to use a before trigger that acquires
a data area and increments its value by one. Surrogate keys are a very valid
RDB construct and are quite helpful in many cases.

______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St.
Tacoma WA 98407


----- Original Message -----
From: <eric.delong@pmsi-services.com>
To: <MIDRANGE-L@midrange.com>
Sent: Wednesday, April 26, 2000 7:09 AM
Subject: Re[4]: how to add 10,000 records to new file with one fi


>
>      Catch 22. Insert before triggers cannot determine the rrn of the
>      record until DB2 adds it to the file. New records are NOT always
>      added to the end of the file (re-use deleted records), so you
>      cannot assume that new_rrn=Current#records+1.
>
>      I think this whole approach is too prone to problems to make it
>      usable. The whole point of relational databases is to present your
>      data logically. Why would you need to artificailly tie the data to
>      its rrn in the file? Seems there are too many ways to mess it up.
>
>      .02
>      eric.delong@pmsi-services.com
>
> ______________________________ Reply Separator
_________________________________
> Subject: RE: Re[2]: how to add 10,000 records to new file with one fi
> Author:  <MIDRANGE-L@midrange.com> at INET_WACO
> Date:    4/25/00 1:57 PM
>
>
> 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
> +---
>
>
>
> +---
> | 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
+---