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!
datastage error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 111
- Joined: Thu Jun 01, 2006 5:12 am
- Location: Detroit
,
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
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
kOTI,
1586-738-7785
1586-738-7785
Re: datastage error
The value marked in red seems to be the problem.sravanthi wrote: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!
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Re: datastage error
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!
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!
sravanthi