Re: Duplicated file names

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

David,


It's Monday morning here (don't know about the rest of the world - yet) 
so maybe I am just not understanding the situation.  So let me 
illustrate what I think I am hearing:

Input FILEA has fields:
FieldA
FieldB
FieldC

Output OUTA has fields:
OutA
OutB
OutC

Output OUTB has fields:
OutA
OutB
OutC

The program is doing something like:

   OutA   =   FieldA
   (etc.)
   IF condition = 'A'
      WRITE   OUTAR
   ELSE
      WRITE   OUTAR
      WRITE   OUTBR
   ENDIF


The fact that OUTA and OUTB have the same field names would not make any 
difference.  In fact, the OUT files could have the same field names as 
the input file (FILEA).  Field names are just user-friendly references 
for memory address locations.  But you knew that so my simple 
illustration is probably inaccurate; i.e., the problem is deeper than my 
little mud puddle.


        * Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



David Foxwell wrote:
> Hi,
>
> I am reading a primary file with the RPG cycle 
>
> for each read, I write to one or both of my output files.
>
> The fields of the second output file are also in the first.
>
> How do I do this without having diffferent names and thus moving my data twice?
>
>
> What I am doing at the moment, is writing to the first file and at LR I use SQL 
> to fill the second file from the first. But that way, I'm reading all the data 
> a second time.
>
> Any ideas? 
>