SQLFetch() Error with ODBC connector
Posted: Tue Jun 26, 2012 7:51 am
I have a sql query in the below format
WITH temp1(col1,col2,col3) as
(
SELECT C1,C2,C3 FROM TABLE1
)
SELECT COUNT(COL1) AS STD,'CLS' AS CLASS1
UNION ALL
SELECT COUNT(COL2) AS HLM,'ABC' AS CLASS1
This query runs successfully on sqlserver and also this is wokring fine on datastage 8.1 sql connector. My problem is my job fails with following error
[IIS-CONN-000004]ODBC function"sqlfetch"
Code=0 Msg=[IBM[DataDirectOEM]][ODBC SQL
dbStatement:dbsFetch:FileCC_OdbcDBStatement.cpp
. Most of the times the job runs successfully.The job fails only some times with this error. Let me know where is fault with my code.
WITH temp1(col1,col2,col3) as
(
SELECT C1,C2,C3 FROM TABLE1
)
SELECT COUNT(COL1) AS STD,'CLS' AS CLASS1
UNION ALL
SELECT COUNT(COL2) AS HLM,'ABC' AS CLASS1
This query runs successfully on sqlserver and also this is wokring fine on datastage 8.1 sql connector. My problem is my job fails with following error
[IIS-CONN-000004]ODBC function"sqlfetch"
Code=0 Msg=[IBM[DataDirectOEM]][ODBC SQL
dbStatement:dbsFetch:FileCC_OdbcDBStatement.cpp
. Most of the times the job runs successfully.The job fails only some times with this error. Let me know where is fault with my code.