Re: SQL for file with multiple formats

Actually I thikl the answer is yes - you have to create an alias for the member ..

-----Original Message-----
From: Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
To: Java Programming on and around the iSeries / AS400 <java400-l@xxxxxxxxxxxx>
Sent: Wed, 30 Apr 2008 22:05
Subject: Re: SQL for file with multiple formats










short answer...NO

Thanks,
Tommy Holden



From:
Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx>
To:
java400-l@xxxxxxxxxxxx
Date:
04/30/2008 04:02 PM
Subject:
SQL for file with multiple formats



Hi
Can i write a SQL statement to read data from a file
which have more then 1 formats?
I have a logical file on AS400 with more then one
formats and i need to read this file using SQL
is it possible or not?

Ashish

A$HI$H



_________________________________________________________________________
___________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.







________________________________________________________________________
AOL's new homepage has launched. Take a tour at http://info.aol.co.uk/homepage/ now.