RE: Accessing data in a file containing a dot.

Bless you Phil.  That did it.  You might just have saved my job. :)

Amy Anuszewski





|--------+------------------------>
|        |          "Phil"        |
|        |          <sublime78ska@|
|        |          yahoo.com>    |
|        |                        |
|        |          11/04/2001    |
|        |          01:57 PM      |
|        |          Please respond|
|        |          to java400-l  |
|        |                        |
|--------+------------------------>
  >-------------------------------------------------------------------|
  |                                                                   |
  |      To:     java400-l@midrange.com                               |
  |      cc:     (bcc: Amy K Anuszewski/WSC)                          |
  |      Subject:     RE: Accessing data in a file containing a dot.  |
  >-------------------------------------------------------------------|




can you use quotation marks:

select * from qs36f."AB.PO"

for example.



> -----Original Message-----
> From: java400-l-admin@midrange.com
> [mailto:java400-l-admin@midrange.com]On Behalf Of AAnuszewski@hammer.net
> Sent: Sunday, November 04, 2001 1:34 PM
> To: java400-l@midrange.com
> Subject: Accessing data in a file containing a dot.
>
>
>
>
>
> I am getting desperate.  I have data stored in a file called
> "AB.PO".  I need to
> access it, but when I try to select  from the table, it thinks AB
> is a library
> name, and not part of the file name.  How can I access the data
> in this file?
>
> Thank you,
> Amy Anuszewski
>
>
> _______________________________________________
> 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.
>

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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