Re: Join & Update

[Jim Langston <jlangston@xxxxxxxxxxxxxxxx>]

Okay, I'm intrigued.  This sounds like it will fix my problem once and for all.

I already have the two separate files created.  I guess my next step is look
through my DDS manuals for Multi format logical files.  After I create this,
I need to write a "record format selector" program and link it to the logical
file somehow.

Okay, looks like I got my work cut out for me, thanks!

Regards,

Jim Langston

Douglas Handy wrote:

> Jim,
>
> >Well, the problem with this is I would still have to go though every program
> >and use the "record format selector program" and if I'm going to do that I
> >might as well break them up into two separate files anyway.
>
> Not true.  That is the whole reason for having a "format selector
> program".  It is tied to the LF description (not your application
> programs) and is called by the system whenever you attempt and add or
> update to the multi-format LF.  The format selector program determines
> which PF it belongs to and passes back the record format name, and
> OS/400 takes care of updating the physical files for you.
>
> You do not need a "format selector program" to *read* multi-format LF
> files, since the system already knows from which PF it came.  You do
> need one to *add* to the LF.  Of course, if you only add to the PF's,
> then you do not need one either.  But this is what you are trying to
> avoid or postpone.
>
> If the LF has the same name as the current file used by the program,
> and you attach a "format selector program" to the LF, then the
> programs can access the LF and still perform adds/updates.
>
> Doug
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---