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]




DB2 & UDB email list listserv db2-l LazyDBA home page