odbc connection
Posted: Wed Nov 22, 2006 9:23 am
hi all,
I am using a odbc stage to access oracle database in one of my job.
It was working fine in production. Recently we added new jobs to the same project and tried to run the whole project for testing and found an error in accessing odbc stage.
I checked the ODBC connections it is working fine.
this job or stage has nothing to do with new jobs added
jobname..oci_stagename.lk_linkname: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was: SELECT
t.col1,
t.col2,
NVL(t.col3, t.col1)
FROM
tablename T
WHERE
T.THREAD_NUM=1
AND (t.col3=?)
UNION
SELECT
t.col1,
t.col2,
NVL(t.col3, t.col1)
FROM
tablename T
WHERE
T.THREAD_NUM=1
AND (T.col1=?)
SQLSTATE=S1009, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Invalid argument value
anyone had same issue or have an answer to it
thanks
I am using a odbc stage to access oracle database in one of my job.
It was working fine in production. Recently we added new jobs to the same project and tried to run the whole project for testing and found an error in accessing odbc stage.
I checked the ODBC connections it is working fine.
this job or stage has nothing to do with new jobs added
jobname..oci_stagename.lk_linkname: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was: SELECT
t.col1,
t.col2,
NVL(t.col3, t.col1)
FROM
tablename T
WHERE
T.THREAD_NUM=1
AND (t.col3=?)
UNION
SELECT
t.col1,
t.col2,
NVL(t.col3, t.col1)
FROM
tablename T
WHERE
T.THREAD_NUM=1
AND (T.col1=?)
SQLSTATE=S1009, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Invalid argument value
anyone had same issue or have an answer to it
thanks