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