Hi folks,

i'm trying to connect to DB2 UDB v 7.2.9 using JDBC Type 4 driver
[com.ibm.db2.jcc.DB2Driver].

I'm getting following error

DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSSH200

What should I do to resolve this?

Thanks
sara

I would try to upgrade the DB2 server to the latest V7 fixpack if you are having trouble using a V8 client/driver to connect.

This is an incompatible consistency token.
Normally, it should suffice to recompile (and bind) your program.

Actually, the LUW manual states it as follows:
Package NULLID.SYSSH200 was not found.
Explanation: The statement cannot complete because the necessary package was not found in the catalog.

So, as I said, just recompile and bind the program.

Hello,

I need an help with retrving results from a stored procedure, I need to correct the syntax which I am not able to get through

Given below are 3 commads, here 1) and 2) works fine, my problem is I need 3) to work fine too.

1) create table emp1 (empno int,SALARY int) (works fine)
2) CREATE PROCEDURE UPDATE_SALARY_10 (IN EMPLOYEE_NUMBER int,IN RATE int) LANGUAGE SQL MODIFIES SQL DATA UPDATE EMP1 SET SALARY = SALARY * RATE WHERE EMPNO = EMPLOYEE_NUMBER (works fine)
3) CREATE PROCEDURE dd (OUT result int) LANGUAGE SQL CONTAINS SQL select empno from emp1 (gives 104 error)

Can someone please help me here, I know its a syntax error but I am not able to get through it.

Thank you
Ashok

You need to bind I think, the 805 error is because you dont bind from the client to the server.
Try using the below two commands

java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://<machinename>.com:<portno>/<databasename> -user <user name> -password <password> -action replace
java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://<machinename>.com:<portno>/<databasename> -user <user name> -password <password> -collection DSNJDBC -action replace



Try

Try the following instead:Make sure that you don't get a -811 at runtime!