Re: multi format logical.

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.