RE: Identity columns and RLA

If you use GENERATED ALWAYS AS IDENTITY then you will be able to WRITE the record using RLA.

If you use GENERATED BY DEFAULT then you may need to create a view that does not include the identity column in order to use RLA to write the record.

The easiest way being to use IDENTITY_VAL_LOCAL in an SQL program.
EXEC SQL SET :RSCPCPRJ = IDENTITY_VAL_LOCAL();

I find using GENERATED ALWAYS and IDENTITY_VAL_LOCAL works well.


Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter Dow
Sent: Wednesday, August 31, 2016 2:06 PM
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Subject: Identity columns and RLA

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