How to set Default Library using tool box classes.

["Kaushal Trivedi" <e_ediam@xxxxxxxxxxx>]

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