: MIDRANGE dot COM Mailing List Archive

SQL & Library lists


AddThis Feed Button


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
I've created an SQL stored procedure, which I'm calling from a Java Servlet
via the Toolbox.

Originally the SP used a hard coded library (schema) name, and extracted the
data fine. However I've now removed the hard coding, as I want the SP to use
the library list to pick of the files. Now I get an error:
"java.sql.SQLException: [SQL0204] MYFILE in QPGMR type *FILE not found."

This is not surprising as we don't have a QPGMR library. I guess it is using
the User Name as a default schema name. How can I get it to use the library
list?

Chris.




Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2007 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact

.

counter