bughunter@ru wrote:
When I try call sql stored procedure on version 7 (win) server from 8.2
fixpack 9 (win32) I got:
C:\SQLLIB\bnd>db2 "call proc(1)"
SQL1109N The specified DLL "SYSIBM.SQLPROCEDURECOLS" could not be
loaded.
DB21085I Instance "DB2TST" uses DB2 code release "SQL07029" with level
identifier "030A0105" and informational tokens "DB2 v7.1.0.98",
"n040510" and
"WR21337".
db2cli, db2ubind - binded.
Help me, please! I can't change server version or client level.
Andy
It isn't going to work I'm afraid if you want to run anything which uses CLI
such as ODBC or JDBC. The V8 universal client now relies on system stored
procedures on the server to obtain a lot of the catalog information used by
CLI. This isn't just for stored procedures : it will even call SPs to get
column and table information. This restriction is documented in the
release notes for V8 I seem to remember.
IBM shipped these stored procedures for mainframe DB2 from V6 upwards (the
procedures themselves are load modules produced from C code), but I don't
know if there are any equivalent ones shipped for DB2 UDB prior to V8.
Looking at the catalog on a V8 server, the routines are also sourced in
modules derived from C programs, so you can't even extract the DDL and
attempt to recreate them.
And since V7 is now out of support you aren't going to get anywhere with
Support. So I really think your only option is to get the server up to V8
level !!!
Sorry.
Phil