[DataStage][SQL Client]Invalid cursor state

vijay.barani · Post by **vijay.barani** » Thu Jan 15, 2009 1:14 am

Hi Friends,

I created a job which has simply
ODBC--->TRANSFORMER--->ODBC

When i tried to run the job it is throwing an error like...

GOM..ODBC_2.DSLink12: DSD.BCIOpenW call to SQLColAttributes(PROJECT_ID) failed.
SQLSTATE=24000, DBMS.CODE=0
[DataStage][SQL Client]Invalid cursor state

Does anybody know about this?Please let me know why this is happening.

srinagesh · Post by **srinagesh** » Thu Jan 15, 2009 7:26 am

Does the query run fine when executed directly at the database.

vijay.barani · Post by **vijay.barani** » Fri Jan 16, 2009 11:46 pm

srinagesh wrote:Does the query run fine when executed directly at the database.

Hi Nagesh,
The query went good in database level.It was my mistake.I hadn't added one column in the target ODBC.Now it is working good.Anyways thank you for your responce Nagesh.

ray.wurlod · Post by **ray.wurlod** » Sat Jan 17, 2009 1:12 am

Please mark this thread as Resolved using the green button at the top of the page.