Hi all, We're trying to run a Stored procedure for the first time in java & get the following error message: Caught SQLException during lookup printing getErrorCode-206 getMessage[IBM][CLI Driver][DB2] SQL0206N "PKGNAME " is not valid in the context where it is used. SQLSTATE=42703 getSQLState42S22 We're connecting to DB2 (version 7, I think), via DB2Connect the run time client, from WSAD 5.1.0. Does anyone have any ideas how to fix it? Many thanks, Louise
Joined: Apr 04, 2002
Forgot to say... The procedure runs fine from a COBOL program - its just a problem accessing it through java.