error with db2udp.dll on db2 version 7

Bill Smith

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

Serge Rielau

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

Bill Smith

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

Serge Rielau

http://www.elink.ibmlink.ibm.com/pub...CTY=US&FNC=ICL

Nov 12 '05 #4