Win a copy of Machine Learning for Business: Using Amazon SageMaker and JupyterE this week in the Jython/Python forum
or Object Design Style Guide in the Object-Oriented programming forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
Sheriffs:
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Joe Ess
  • salvin francis
  • fred rosenberger

Db2 SQL1109N error

 
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
 
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!!!
 
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.
 
It's a tiny ad only because the water is so cold.
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!