datastage error

[sravanthi]

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!

[bollinenik]

,
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"






from thi squery just check this DROPDDL='DROP TABLE USERSQL='UPDATE sptdr1.ITEM_PUBL_EVNT ........in this usersql=update ur suing is wrong just change that query then it will work

[DSguru2B]

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!

The value marked in red seems to be the problem.

[sravanthi]

hi ,

I have tried removing thet semicolon at the end even then it is showing the error:

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 DUMMY INTEGER NOT NULL
)
',
DROPTABLE='No',
GENDROPDDL='Yes',
DROPDDL='DROP TABLE USERSQL='Update sptdr1.ITEM_PUBL_EVNT Set STAT_C=\'U\' Where STAT_C=\'1\' OR STAT_C=\'5\'
',
CONTBEFORESQL='NO',
CONTAFTERSQL='NO',
GENSQL='No',
DSTxnSize=0,
DSSQLType={DUMMY=5},
DSSQLPrecision={DUMMY=5},
DSSchema='record
(
DUMMY:int16;
)'
} is not a valid property list: Expected "," or "}", got: "Update"

what could be the reason please suggest.

Thank!