Well, well, well!
It's Adolfo! Hehe. How have you been? Try the following example.
db2 load from tab32.ixf of ixf modified by identityignore replace into DEPDB.KM_FINGERPRINT
It's Fridayyyyyyyyy! Partyyyyyyyyyyy! 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 Dr. Eric J. Smith 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: Adolfo [mailto:db2udbdba-ezmlmshield-x93635093.[Email address protected]
Sent: Thursday, January 24, 2008 11:46 AM
To: LazyDBA Discussion
Subject: problem LOAD
Hi Gurus,
I need move information of the Server a other server, but I have table
declared with column type GENERATED BY DEFAULT, in the moment of the run
LOAD this is error
db2 "load from contacto_usr of ixf MODIFIED BY generatedoverride insert into
contacto_usr"
SQL3526N The modifier clause "GENERATEDOVERRIDE" is inconsistent with the
current load command. Reason code: "3".
I need to have the values for column ID_CONTACTO
Attach ddl an data file
DDL
CREATE TABLE ATM.CONTACTO_usr
(ID_CONTACTO INTEGER NOT NULL GENERATED BY DEFAULT
AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20, MINVALUE 1,
MAXVALUE 2147483647, NO CYCLE, NO ORDER),
NOM_CONTACTO VARCHAR(80) NOT NULL,
TELEFONO VARCHAR(20) NOT NULL
)
DATA CAPTURE NONE
IN DIRMEDH_DAT1
INDEX IN DIRMEDH_IND1;
ALTER TABLE ATM.CONTACTO_usr
LOCKSIZE ROW
APPEND OFF
NOT VOLATILE;
COMMENT ON TABLE ATM.CONTACTO_usr
IS 'CONTACTO';
ALTER TABLE ATM.CONTACTO_usr
ADD CONSTRAINT pk_contacto_usr PRIMARY KEY
(ID_CONTACTO
);
data for load
1,"ADOLFO","7222102456"
2,"JOSE","7222101010"
3,"PEDRO","7222101111"
4,"JUAN","7222102222"
5,"ERIKA","7222103333"
10,"LUCIA","7222104444"
6,"ANA","7222105555"
7,"MAYTHE","7222106666"
8,"JESUS","7222102456"
9,"ALBERTO","7222101010"
40,"LUIS","7222101111"
45,"SONIA","7222102222"
100,"KAREN","7222103333"
20,"ANGEL","7222104444"
30,"CESAR","7222105555"
33,"FERNANDO","7222106666"
Thanks
Adolfo Roldán Albarrán
Analista Técnico - DBA DB2
Harbinter Soluciones S.A. de C.V.
Tel. (55) 5255 2955
<mailto:[Email address protected] [Email address protected]
---------------------------------------------------------------------
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