Re: auto generated ID as primary key

This worked fine for me on the same system.

create table rob.jv (
L_ID for column ID
BIGINT not null generated always as
identity (start with 1 increment by 1),
YesICanUseMoreThan4CharactersToDefineAColumn char (10),
CONSTRAINT jvprimarykey PRIMARY KEY (l_id));
insert into rob.jv (YesICanUseMoreThan4CharactersToDefineAColumn)
values('A') with nc;
insert into rob.jv (YesICanUseMoreThan4CharactersToDefineAColumn)
values('B') with nc;
cl: clrsavf rob/rob;
cl: SAVOBJ OBJ(JV) LIB(ROB) DEV(*SAVF) OBJTYPE(*FILE) SAVF(ROB/ROB);
cl: crtlib rob2;
cl: RSTOBJ OBJ(JV) SAVLIB(ROB) DEV(*SAVF) OBJTYPE(*FILE) SAVF(ROB/ROB)
RSTLIB(ROB2);
insert into rob2.jv (YesICanUseMoreThan4CharactersToDefineAColumn)
values('C') with nc;
select * from rob2.jv for fetch only;
This returned 1-3 for L_ID.

So I saved it again and restored it to another system.
I inserted another row
Did another select
This returned 1-4 for L_ID.

IBM i 7.3 with PTF groups updated as of mid December.

Please show one of your inserts. I'm curious if you're assigning a value
for L_ID or something.

Keep in mind that the last used is not stored in some external table. It's
in the object header information itself.

Rob Berendt