SQL0969N - error in module "DSNXOLTD"
Posted: Mon Mar 03, 2008 12:57 pm
Hi,
One of teh developers just got this error in one of his jobs. Has anyone seen this before?
Thanks - - John
Detail..odbcDetail.DSLink2: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was:SELECT A.CNTRCT_NUM, B.CNTRCT_TYP_CD , A.ERF_PROC_YR,
A.GEN_YR , 'MOVECOUT', A.IYB_AMT
FROM NZ9X.DB_ERF_IIA A,
NZ9X.ERF_CNTRCT B
WHERE
A.ROW_STAT = 'A'
AND A.CALC_TYPE_CD = 'CASHOUT'
AND A.CALC_DTM > '2007-01-01 00:00:00'
AND B.ROW_END_DT = '9999-12-31'
AND A.CNTRCT_NUM = B.CNTRCT_NUM
SQLSTATE=56038, DBMS.CODE=-4700
[DataStage][SQL Client][ODBC][IBM][CLI Driver][DB2] SQL0969N There is no message text corresponding to SQL error "-4700" in the message file on this workstation. The error was returned from module "DSNXOLTD" with original tokens "". SQLSTATE=56038
One of teh developers just got this error in one of his jobs. Has anyone seen this before?
Thanks - - John
Detail..odbcDetail.DSLink2: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was:SELECT A.CNTRCT_NUM, B.CNTRCT_TYP_CD , A.ERF_PROC_YR,
A.GEN_YR , 'MOVECOUT', A.IYB_AMT
FROM NZ9X.DB_ERF_IIA A,
NZ9X.ERF_CNTRCT B
WHERE
A.ROW_STAT = 'A'
AND A.CALC_TYPE_CD = 'CASHOUT'
AND A.CALC_DTM > '2007-01-01 00:00:00'
AND B.ROW_END_DT = '9999-12-31'
AND A.CNTRCT_NUM = B.CNTRCT_NUM
SQLSTATE=56038, DBMS.CODE=-4700
[DataStage][SQL Client][ODBC][IBM][CLI Driver][DB2] SQL0969N There is no message text corresponding to SQL error "-4700" in the message file on this workstation. The error was returned from module "DSNXOLTD" with original tokens "". SQLSTATE=56038