We have a tableA, in that table Primary_key column having auto increment
CREATE TABLE "tableA" (
"table_KEY" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 20))
could you please tell me the how to get last generated column?
i have searched for "db2 describe table SYSIBM.SYSSEQUE NCES" but i did not get the proper information,
Pls Advise me...
CREATE TABLE "tableA" (
"table_KEY" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 20))
could you please tell me the how to get last generated column?
i have searched for "db2 describe table SYSIBM.SYSSEQUE NCES" but i did not get the proper information,
Pls Advise me...