Multiple queries in ODBC Stage
Posted: Wed Jan 27, 2010 12:11 pm
Here are the two queries I have written in the ODBC stage in a Server job..
INSERT INTO DATALOAD(RECORDKEY, RECORDTYPE, MX_MESSAGE, DSJOBNAME) VALUES (?,?,?,?);
UPDATE DATALOADHEADER SET ERRORCOUNT = 0 WHERE JOBNAME = DSJOBNAME;
The error I am getting is :
DSD.BCIOpenW call to function SQLPrepare failed.
UPDATE DATALOADHEADER SET ERRORCOUNT = 0 WHERE JOBNAME = DSJOBNAME
SQLSTATE=S0022, DBMS.CODE=207
[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Invalid column name 'DSJOBNAME'.
----------------------
DSJOBNAME is in the input link to ODBC stage , how can I overcome this?
INSERT INTO DATALOAD(RECORDKEY, RECORDTYPE, MX_MESSAGE, DSJOBNAME) VALUES (?,?,?,?);
UPDATE DATALOADHEADER SET ERRORCOUNT = 0 WHERE JOBNAME = DSJOBNAME;
The error I am getting is :
DSD.BCIOpenW call to function SQLPrepare failed.
UPDATE DATALOADHEADER SET ERRORCOUNT = 0 WHERE JOBNAME = DSJOBNAME
SQLSTATE=S0022, DBMS.CODE=207
[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Invalid column name 'DSJOBNAME'.
----------------------
DSJOBNAME is in the input link to ODBC stage , how can I overcome this?