Re: sql statement

Hi
it depends on the naming conventions you use in your driver properties.
default is *SQL and the you have to use SELECT * FROM MYLIB.MYFILE
if this doesn't work you should change your properties (part of the url
during connect) to use *sql.

Dieter

Michael Knezevic schrieb:
> hi,
>
> i got a simple problem and i think i sometime in the past
> knew the answer, but currently i don't.
> i want to do a simple query via jdbc on a file on the
> as400.
>
> now what i a qualified name for a file? do i have to put
> it the IFS-way: mylib.LIB and myfile.FILE  ???
> because i always get the error message:
>
> ERROR: [SQL5016] Qualifizierter Objektname PAEUMS nicht
> gultig.
>
> in english it would be:
> qualified object name PAEUMS not valid.
>
> PAEUMS is my file (and it is really there).
>
> so some help would be appreciated.
>
> thanx.
> _______________________________________________
> This is the Java Programming on and around the iSeries /
> AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
>
>
>