Re: multi format logical.

SUPPOSE  I need to delete all records for a particular invoice number,
regardless of where they reside within the 2 PFs?
 Steve <steema@xxxxxxxxxxxxx> 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).
>
> Logfile combines the 2 underlying PFs into a single view. If your program
> reads the whole of Logfile you will get all the records from both physical
> files. The file INFDS has a field that contains the name of the format
> last
> read. This allows your program to determine which underlying physical file
> it is processing, and therefore which physical file will be affected by an
> update or delete.
>
> --
> Dave...
>
>
> ______________________________________________________________________
> This message may contain confidential information which may also be
> legally privileged and is intended only for the use of the parties to whom
> it is addressed. If you are not an intended recipient you are hereby
> notified that any disclosure, copying, distribution or use of any
> information in this e-mail is strictly prohibited. If you receive this
> message in error please notify the sender by return e-mail and then
> destroy it. Further, we make every endeavour to keep our network free from
> viruses. However, you do need to verify that this e-mail and any
> attachments are free of viruses as we can take no responsibility for any
> computer viruses which might be transferred by way of this e-mail. All
> information and attachments remain the property of Stolt Offshore Group
> and should be held as confidential.
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>