Has anyone successfully imported data into a table with an identity column?
I want to override the identity values and insert values from a file.
Here is the table layout:
CREATE TABLE "NSUSER "."FACRESOURCETYPE" (
"" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY
( START WITH +1 , INCREMENT BY +1 , NO CACHE )
,
"NAME" VARCHAR(50) NOT NULL ,
"ORDINAL" INTEGER )
IN "USERSPACE1" ;
I want to override the identity values (FACRESOURCETYPE_ID) and insert values from a
file.
Contents of the data file to be loaded:
11,Screen,1
22,Report,2
33,Query,3
44,Batch Process,4
55,Manual Process,5
66,Form,6
77,Other,7
I've run the following command and numerous other import options. The
FACRESOURCETYPE_ID ends up incrementing the values starting where it left off and
incrementing the identity by one.
db2 import from FacilitatorResourceType.csv of del modified by identityignore
replace into nsuser.FACRESOURCETYPE
Contents of table after last import:
db2 "select * from nsuser.FACRESOURCETYPE"
FACRESOURCETYPE_ID NAME ORDINAL
------------------ --------------------------------------------------
-----------
29 Screen 1
30 Report 2
31 Query 3
32 Batch Process 4
33 Manual Process 5
34 Form 6
35 Other 7
7 record(s) selected.
Thanks in advance for your assistance.
Bernie Schwanbeck
RBC Dain Rauscher does not accept buy, sell or cancel orders by e-mail, or any
instructions by e-mail that would require your signature. Information contained in
this communication is not considered an official record of your account and does not
supersede normal trade confirmations or statements. Any information provided has been
prepared from sources believed to be reliable but is not guaranteed, does not
represent all available data necessary for making investment decisions and is for
informational purposes only.
This e-mail may be privileged and/or confidential, and the sender does not waive any
related rights and obligations. Any distribution, use or copying of this e-mail or
the information it contains by other than an intended recipient is unauthorized. If
you receive this e-mail in error, please advise me (by return e-mail or otherwise)
immediately.
Information received by or sent from this system is subject to review by supervisory
personnel, is retained and may be produced to regulatory authorities or others with a
legal right to the information.
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
