Re: sql statement

["Dave Wall" <dawall@xxxxxxxxxx>]

Dieter is correct.  I will only add with the Toolbox driver the library
name is always first.  With *SQL naming the format is LIBRARY.FILE.  With
*SYSTEM naming it is LIBRARY/FILE.

David Wall
AS/400 Toolbox for Java




                      Dieter.Bender@t-o
                      nline.de                 To:       java400-l@midrange.com
                      Sent by:                 cc:
                      java400-l-admin@m        Subject:  Re: sql statement
                      idrange.com


                      01/18/2002 05:53
                      AM
                      Please respond to
                      java400-l





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.
>
>
>
_______________________________________________
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.