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

error with db2udp.dll on db2 version 7

P: n/a
I am trying to run the ddl statements to create a stored procedure on a db2
server machine (W2K, DB2 Universal Database, version 7, 5648-B91 through
5648-B99, 5648-C34). The stored procedure was written and debugged on db2
udb version 8.1 on my laptop.

The create procedure statement fails with SQL1109N unable to load db2udp.dll
(which is not on the server). The stored procedure is LANGUAGE SQL.

Will installing the DB2 Stored Procedure Application Development Client on
the db2 server (see IBM link
http://www-306.ibm.com/software/data...pb/client.html ) allow the
ddl statements to successfully create the procedure on version 7, The SP
creates and runs just fine in version 8.1.

I have seen other messages in the news archive that suggest the Application
development client AND a C compiler be installed on the db2 server. (I don't
quite understand this, as I don't know where db2 is configured to call the
compiler/linker for the C compiler)...

Thanks, Bill
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Why are you looking at zOS docs?
Take a look here:
http://publib.boulder.ibm.com/infoce..._spconfigc.htm
(should work the same IN V7.

Cheers
Serge
Nov 12 '05 #2

P: n/a
Thanks for the pointer, I did not notice that the google search had sent me
to the z/os version....Where is the top level URL jumping off point into the
product documentation for the different versions of db/2? Looking at the
pages for the link you supplied I can find nothing on the screen (or a link
to a TOC, etc ) that tells me what version of db2 the document I am looking
at is for.
Bill

"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:2t*************@uni-berlin.de...
Why are you looking at zOS docs?
Take a look here:
http://publib.boulder.ibm.com/infoce..._spconfigc.htm
(should work the same IN V7.

Cheers
Serge

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.