Hi all,

Can you please tell me what is this error, when I try to call a DB2 Stored Procedure written in SQL from java app?

I am using callable statement in java and the syntax is correct and i use type 2 jdbc driver.

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL10013N The specified library "/dsk7/db2/install/sqllib/function/VerificaDistinta" could not be loaded.

In this error "VerificaDistinta" is my stored procedure and it is AIX 4.3.3 and complied correctly with xlc.

The same procedure is working correctly when I call from DB2 in AIX and from Win XP with DB2 Runtime client.

This problem is encountered only when i try to call the SP from java.

Please help me. I went thru all the threads in the forum before posting this and also went the ibm site also. But none could help me.

Waiting for some help.