sql error

[Mark j]

what does this error mean

DSD.BCIPut call to SQLExecute failed.

SQLSTATE=60, DBMS.CODE=-805
[DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver][DB2]7604


Thanks
Mark

[mandyli]

Following error related to DB2 odbc connection error.


[quote]SQLSTATE=60, DBMS.CODE=-805
[DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver][DB2]7604 [/quote]

Which stage you are using ODBC stage or DB2 API stage.

[ray.wurlod]

That it's BCI.Put indicates that it's an ODBC or UV stage. Since the message is from DB2, we must assume the former; you can't get at a DB2 database through a UV stage!

There's more to this error message. We need to see the response from the database server, and we need to know what error code -805 means in that database. Reset the job, and see if there's anything in the "from previous run" event that might aid diagnosis. (I think there's more "message" following the 7604.)

Can you also post the INSERT/UPDATE statement(s) that the link is using?

Have you verified that this is valid SQL according to what you want to do?

[Neil C]

-805 error code in DB2 means
"DBRM OR PACKAGE NAME NOT FOUND IN PLAN"

So go to the DB2 system and find out what package or plan it is complaining about and get the DB2 DBA to rebind it for you.

What method of accessing DB2 are you using? DB2 Connect, Oracle Transparent Gateway, something else?