Re: How to set Default Library using tool box classes.

[David Gibbs <david@xxxxxxxxxxxx>]

I think this question would be more appropriately posed in the
JAVA400-L mailing list.

Folks, please post followups there ... not here.

Thanks!

david
 
> 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=20
> 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=20
> 
> com.ibm.as400.access.AS400JDBCDriver d =3D new =
> com.ibm.as400.access.AS400JDBCDriver();
>   com.ibm.as400.access.AS400 o =3D new =
> com.ibm.as400.access.AS400("MyMachine",userID,passWord);
>   o.setGuiAvailable(false);
>   Connection c =3D 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 is the WEB400 Mailing List!
| To submit a new message, send your mail to WEB400@midrange.com.
| To subscribe to this list send email to WEB400-SUB@midrange.com.
| To unsubscribe from this list send email to WEB400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---