Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Db2 SQL1109N error

 
vikram nalagampalli
Ranch Hand
Posts: 91
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I am trying to connect to an remote database server norder to acess as tored procedure.
I configured an Db2 client on my M/c to talk to the remote server. Connection came out to be sucessful but then i am gettign the following error. Can any one help me with this.

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1109N The specified
DLL "Insert_OIG_SSNs.insert_OIG_SSNs" could not be loaded.
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExce
ptionGenerator.java:270)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExce
ptionGenerator.java:207)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExcep
tionGenerator.java:458)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStateme
nt.java:2110)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute(DB2PreparedStatemen
t.java:3887)
at OigMQ.insertSSN(OigMQ.java:175)
at OigMQ.main(OigMQ.java:55)

Thank you
Regards,
Vikram
 
Chetan M
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Vikram,
Just check out the links below.. hope are of help to u..
http://www-3.ibm.com/cgi-bin/db2www...upport/document.d2w/report?fn=db2l088.htm
https://aurora.vcu.edu/db2help/db2p0/frame3.htm#clitips
http://www.ibm.com/Search?v=11&lang=en&cc=us&q=SQL1109N
#####################################################
HAKUNAMATATA!!!
 
Karthi Bala
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ciao,
The problem can be resolved in case of Java Stored Procedures by placing the .class files in the <DB2INSTALL>\sqllib\function folder.
Karthi.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic