DSXchange

Posted: **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.

Posted: **Thu Jan 15, 2009 7:26 am**

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

Posted: **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.

Posted: **Sat Jan 17, 2009 1:12 am**

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