RE: Select from [file with multiple record formats]

["Bob Cozzi \(RPGIV\)" <cozzi@xxxxxxxxx>]

Well you asked this question on an RPG list, but it is worded like you
really wanted an SQL question answered.

RPG allows you to read multi-format files, no problem. Typically a
multi-format file is either a Logical view built over two or more
physical files, or it is a program described file. In any case, it will
be no problem for RPG to read it.

In SQL... well???

Bob Cozzi
cozzi@rpgiv.com
Visit the on-line  Midrange  Developer  forum at: http://www.rpgiv.com


> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]
On
> Behalf Of Ted Barry
> Sent: Thursday, March 14, 2002 4:43 PM
> To: rpg400-l@midrange.com
> Subject: Select from [file with multiple record formats]
>
> I've never had to deal with this one until now...  Is it possible to
select
> and/or even update a file with multiple record formats?
>
> Syntax anyone?
>
> Thanks,
>   Ted
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.