Well, well, well,
It's Khan Nadeem! Hehe. How have you been? The code below mabe what
you are looking for!
--"LOAD" DATA FROM A TABLE THAT HAS AN IDENTITY COLUMN
--CREATED AS "GENERATED ALWAYS AS IDENTITY"
--USING IXF FILES FROM DB2MOVE OR EXPORT COMMANDS
1. db2cmd
2. db2 connect to sample4 user edwarde using supply
3. db2 import from tab8.ixf of ixf create into EDWARDE.EMPLOYEE2
4. db2 load from tab8.ixf of ixf modified by identityoverride
insert into EDWARDE.EMPLOYEE2
5. db2 load from tab8.ixf of ixf modified by identityoverride
replace into EDWARDE.EMPLOYEE2
last, you must rest the identity column.
--Reset a DB2 Identity Column
ALTER TABLE EDWARDE.IDENTITY1 ALTER COLUMN ID1 RESTART WITH 4;
It's almost Fridayyyyyyyyyyyyy! Hehe.
Have a great Day!
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Khan Nadeem
[mailto:db2udbdba-ezmlmshield-x59587762.[Email address protected]
Sent: Tuesday, March 27, 2007 7:21 AM
To: LazyDBA Discussion
Subject: import problem
Hi gurus
I have a database with 100 tables having few records iin each table
Now I have created almost similar tables + some additional in a
different schema but without data having same realtions
I need to insert data in the new tables
I tried it by EXP, IMP but it throws error as there are certain
GENERATED columns
So is there any method in import which suppresses this issue
Also I have used DB2MOVE (EXPORT AND IMPORT )but unable to insert bcos
of same problem
So someone pls help me with the way out
Thanks in advance
Nadeem
This message contains information that may be privileged or confidential
and is the property of the Capgemini Group. It is intended only for the
person to whom it is addressed. If you are not the intended recipient,
you are not authorized to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all
copies of this message.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page