How to set Default Library using tool box classes. -- WEB400

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Hi everybody,

i am making a connection to AS400 using as400 object from java toolbox for AS400. I want to access a particular library which is the default library for my

profile. I have all the rights for that library and the file which i m accessing.

But when i try to fetch data using SQL and following code

com.ibm.as400.access.AS400JDBCDriver d = new com.ibm.as400.access.AS400JDBCDriver();
  com.ibm.as400.access.AS400 o = new com.ibm.as400.access.AS400("MyMachine",userID,passWord);
  o.setGuiAvailable(false);
  Connection c = d.connect (o);

I get this error.

Exception from getBase java.sql.SQLException: [SQL0204] PARMFILE in DTRIVEDI t
ype *FILE not found.

However if i explicitly specify the library as in SELECT * FROM LIB.FILE

i get results.

Could any body explain why and how to get out of this.

Thanxx Kaush

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.