while loading the PK COLUMN data into table I am getting the duplicate key in a table because of PK COLUMN having auto increment.
My requirement is what ever data having the ORIGINAL TABLE
that data i want to load into table..
Could please tell me the how to load the this type of data & which options i mentioned while loading?
naveendb2dba
Last Activity: Feb 28 '11, 08:03 AM
Joined: Jun 29 '09
Location:
-
How to load the generated column data into table?
-
how to find out the last generated key column in db2?
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... -
how to store the multiple languages data into table?
I have table A,this table having the comments column, Now the requirement is 'comments' needs to store all language like Japanese, Chinese etc.
I am using the db2v9.5 database
db code page-1208
code set-UTF-8
please advise me.. -
how to identify the all the dbpartitions up and running?
I have 5 db partitions in my system how to identify the partitions are properly working are not?
No activity results to display