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
SQL0969N - error in module "DSNXOLTD"
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
An SQLCODE181 is returned from DSNXOLTD for a DATE function having a timestamp argument. The SQL ref indicates that this is a supported case.
Example,
SELECT * FROM T1 WHERE EFFDT=DATE('2003-07-11-16.50.18.000000');
Also,
SELECT * FROM T1 WHERE EFTME=TIME('2002-10-31-19.46.25.903778');
fails as well. SQLCODE180 from DSNXOLTD. As a workaround, the CAST function can be used
SELECT * FROM T1 WHERE EFFDT =
CAST(DATE('2003-07-11-16.50.18.000000') AS DATE);
Check here: http://www-1.ibm.com/support/docview.ws ... wg1PQ76792
Example,
SELECT * FROM T1 WHERE EFFDT=DATE('2003-07-11-16.50.18.000000');
Also,
SELECT * FROM T1 WHERE EFTME=TIME('2002-10-31-19.46.25.903778');
fails as well. SQLCODE180 from DSNXOLTD. As a workaround, the CAST function can be used
SELECT * FROM T1 WHERE EFFDT =
CAST(DATE('2003-07-11-16.50.18.000000') AS DATE);
Check here: http://www-1.ibm.com/support/docview.ws ... wg1PQ76792
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle