Our developers are starting to work with SQL-based stored procedures (SP) & have run into a problem that I'm unable to resolve. Our environment: the DB2 server is running DB2 V7.2 fixpak 8 on AIX 4.3.3; the client is running Business Objects (BO) on a WIN 2K Professional laptop.
When the developer attempts to execute the SP via BO using the ID busobj, the following error is received: [IBM][CLI Driver][DB2/6000] SQL10013N The specified library "/db2/db2inst1/sqllib/function/DB2INST1.GET_DR1_INFO" could not be loaded. SQLSTATE:-10013 When I execute the SP from the AIX command line prompt locally on the server (db2 "call db2inst1.get_dr1_info(13277,20020603101000)") using the ID db2inst1, the SP is executed & seems to work properly. The external name for the SP is P0035990 & its schema is DB2INST1. I copied the P0035990 (no suffix) file to the /db2/db2inst1/sqllib/function directory & still receive the SQL10013N error. Though the error doesn't seem to point to a problem with privileges, I've reviewed all privileges that I can think of & they appear to be fine. I've checked for SQL10013N just about everywhere I can think of - IBM's DB2 Knowledgebase, the listserv archives (there were some 'hits', but none really indicated the solution) & even via Google, but still haven't found a resolution. I'd greatly appreciate it if someone could provide some insight as to the cause & resolution of this error. Thanks for your time & assistance. ===== Marshall Fuqua [EMAIL PROTECTED] - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
