HI,

I am trying to load data from 1 table to similar definition table both of them having 1 identity column defined as :

"ILN_KEY" BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (
START WITH +5969613
INCREMENT BY +1
MINVALUE +5969613
MAXVALUE +9223372036854775807
NO CYCLE
NO CACHE
NO ORDER

I am using a load from cursor. I have used all the file type mods like generatedoverride,ignor and missing but everytime I am getting the same error :

SQL3526N The modifier clause "GENERATEDMISSING" is inconsistent with the
current load command. Reason code: "3".

Here are the cmds that I am using:

db2 "declare loadcur cursor for select * from db2cods.A"
db2 "load from loadcur of cursor modified by generatedmissing insert into db2cods.A_TEMP nonrecoverabl
e"
db2 "set integrity for db2cods.A_TEMP generated column immediate unchecked"
db2 "select count(*) from db2cods.Awith ur"
db2 "select count(*) from db2cods.A_TEMP with ur"

Can anybody help me.

Thanks,
Anirban.

try identity.... modifiers instead of generated.... modifier.

You can also alter the table to set the indentity column to generated by default (depending on what version you have). I almost always use "generated by default" instead of "generated always".

The other thing to do is remove the identity column from your load cursor and let DB2 do as you had already instructed and generate the identity number.
Also, I completely agree with Marcus why would you use generated ALWAYS? This means you can never reload data you may have archived deleted/etc and keep the same number. You can't unload the entire contents from prod to load into a test system etc...
Dave