datastage error
Posted: Wed Jun 14, 2006 4:28 am
hi,
I'm using rogenerator and db2_udb_api stage.Rowgenerator generates dummy colmn and api stage for updation.Query used is UPDATE schema.ITEM_PUBL_EVNT SET STAT_C='2' WHERE STAT_C='U';
But the job is getting aborted.the log is DB2_UDB_API_ITEM_PUBL_EVNT: When processing argument -inlinkpropsWhen processing input link property list: {
TRANSSIZE=100,
PARRARYSIZE=50,
INPUTMODE='User-defined SQL',
CREATETABLE='No',
GENCREATEDDL='Yes',
CREATEDDL='CREATE TABLE INTF_TASK_ID DECIMAL(38,10),
DIR_ITEM_I DECIMAL(38,10),
EVNT_I DECIMAL(38,10),
INTF_I DECIMAL(38,10),
STAT_C CHAR(1),
FEED_I DECIMAL(38,10),
CRTE_TS TIMESTAMP,
UPDT_TS TIMESTAMP
)
',
DROPTABLE='No',
GENDROPDDL='Yes',
DROPDDL='DROP TABLE USERSQL='UPDATE sptdr1.ITEM_PUBL_EVNT SET STAT_C=\'2\' WHERE STAT_C=\'U\';',
CONTBEFORESQL='YES',
CONTAFTERSQL='YES',
GENSQL='No',
DSTxnSize=0,
DSSQLType={dummy=4},
DSSQLPrecision={dummy=1},
DSSchema='record
(
dummy:int32;
)'
} is not a valid property list: Expected "," or "}", got: "UPDATE"
Can anyone tell me what is my mistake and correct me.
Thanks!
I'm using rogenerator and db2_udb_api stage.Rowgenerator generates dummy colmn and api stage for updation.Query used is UPDATE schema.ITEM_PUBL_EVNT SET STAT_C='2' WHERE STAT_C='U';
But the job is getting aborted.the log is DB2_UDB_API_ITEM_PUBL_EVNT: When processing argument -inlinkpropsWhen processing input link property list: {
TRANSSIZE=100,
PARRARYSIZE=50,
INPUTMODE='User-defined SQL',
CREATETABLE='No',
GENCREATEDDL='Yes',
CREATEDDL='CREATE TABLE INTF_TASK_ID DECIMAL(38,10),
DIR_ITEM_I DECIMAL(38,10),
EVNT_I DECIMAL(38,10),
INTF_I DECIMAL(38,10),
STAT_C CHAR(1),
FEED_I DECIMAL(38,10),
CRTE_TS TIMESTAMP,
UPDT_TS TIMESTAMP
)
',
DROPTABLE='No',
GENDROPDDL='Yes',
DROPDDL='DROP TABLE USERSQL='UPDATE sptdr1.ITEM_PUBL_EVNT SET STAT_C=\'2\' WHERE STAT_C=\'U\';',
CONTBEFORESQL='YES',
CONTAFTERSQL='YES',
GENSQL='No',
DSTxnSize=0,
DSSQLType={dummy=4},
DSSQLPrecision={dummy=1},
DSSchema='record
(
dummy:int32;
)'
} is not a valid property list: Expected "," or "}", got: "UPDATE"
Can anyone tell me what is my mistake and correct me.
Thanks!