By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

Help! Call sql procedure - SQL1109N The specified DLL "SYSIBM.SQLPROCEDURECOLS

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.