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.
SQLFetch() Error with ODBC connector
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Mon Apr 23, 2012 12:28 pm
Re: SQLFetch() Error with ODBC connector
Hi Smile.
Can you please provide me at what ratio job is aborted with your given error.
As per my understanding , due to space issue or server may be down at the time of job executes.
Request you please re check and let us know.
Thanks
Sree
Can you please provide me at what ratio job is aborted with your given error.
As per my understanding , due to space issue or server may be down at the time of job executes.
Request you please re check and let us know.
Thanks
Sree
-
- Participant
- Posts: 15
- Joined: Mon Apr 23, 2012 12:28 pm
Hi Sree,
I have set of jobs that are being executed simultaneously. I trigger all of them from autosys. Even I feel that there is an issue with space. The job mostly fails when other jobs also running. Other wise its absolutely fine.
Can you suggest another approach for the sql query which does not consume much memory. I have close to 40 columns in my original table
I have set of jobs that are being executed simultaneously. I trigger all of them from autosys. Even I feel that there is an issue with space. The job mostly fails when other jobs also running. Other wise its absolutely fine.
Can you suggest another approach for the sql query which does not consume much memory. I have close to 40 columns in my original table
Smile ![Smile :)](./images/smilies/icon_smile.gif)
![Smile :)](./images/smilies/icon_smile.gif)