Re: Identity columns and RLA

[Peter Dow <petercdow@xxxxxxxxx>]

Thanks Alan. I saw that with SQL you can override the generated identity 
column value, and got to wondering if writing a value with RLA would do 
something like that.


On 8/31/2016 1:14 PM, Alan Campin wrote:
> It works fine. Only way I know is with SQL or by reading the last record
> but SQL statement is no big deal. Only one line of code.
>
> On Wed, Aug 31, 2016 at 1:05 PM, Peter Dow <petercdow@xxxxxxxxx> wrote:
>
> > What happens when writing a record with RLA to a table that has an
> > identity column?
> >
> > Assuming it actually works, i.e. ignores the value in the identity column
> > on the WRITE, is there a way to get the value assigned to the identity
> > column?
> >
> > --
> > *Peter Dow* /
> > Dow Software Services, Inc.
> > 909 793-9050
> > petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
> > pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /
> >
> > --
> > This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> > mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.