Re: 2 formats in a LOGICAL

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

This is definitely a question for the RPG list here. You are dealing 
with a multiple-format logical file. This is not usable by SQL, as 
far as I know. The "good old way" was to specify as a keyed file, 
then CHAINing or READing as you would for single-format files. But 
you a record identifier that you check on each read to see which one 
you are reading. That is specified in an I-spec, IIRC.

I recommend the ILE RPG Programmer's Guide at 
www.iseries.ibm.com/infocenter for details. Look up "multiple format 
logical files" there.

And ask the folks on the RPG list, who probably have better memories than I.

HTH
VErn

At 07:53 PM 12/21/2005, you wrote:

> HI I have to use a logical that is composed of 2 files (PF), let us call
> it Logfile. The names of the fields that are designated as Keys, are the
> same. I am not sure as to process this in RPG. Do I use the READ LOGFILE
> method, am I going to get all records. Is there a better way to obtain the
> data, perhaps via SQL?
>
> I will need to allow the users to either Change some of the fields in this
> file, or to Delete a record ( but no add).
>
> Thanks,
> Steve
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.