SQL error Messages
Posted: Mon May 13, 2002 10:40 pm
Hi All,
While executing jobs with ODBC stages often I get the following 2 errors which I am unable to comprehend:
1)Invalid Cursor state.
2) SQL statement has incorrect number of result columns( this error occurs when I use a ODBC stage for Lookup)
Please help me in understanding why these errors occur and how to solve them.
Could someone also give some clue on how to use stored procedures through Datastage
Thanks in advance..
Regards,
Nilotpal
While executing jobs with ODBC stages often I get the following 2 errors which I am unable to comprehend:
1)Invalid Cursor state.
2) SQL statement has incorrect number of result columns( this error occurs when I use a ODBC stage for Lookup)
Please help me in understanding why these errors occur and how to solve them.
Could someone also give some clue on how to use stored procedures through Datastage
Thanks in advance..
Regards,
Nilotpal