467,145 Members | 1,026 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,145 developers. It's quick & easy.

error with db2udp.dll on db2 version 7

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
  • viewed: 1622
Share:
3 Replies
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
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.

Similar topics

reply views Thread by Morten Gulbrandsen | last post: by
6 posts views Thread by Peter Frost | last post: by
2 posts views Thread by Mary | last post: by
7 posts views Thread by p | last post: by
5 posts views Thread by Bruce Schechter | last post: by
2 posts views Thread by akhilesh.noida@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.