Re: Viewing the contents of a multi format logical

Hi Scott,

As specified, this logical should show you all of the fields from each record in
WUDPTP and WUSTDP.
If a field is showing as blank, then that means that the field is blank on the
physical file.

You should be able to check it with Query/400. Assuming that the problem is with
the WUDEPT format, select the file in Query and specify the format. Spot the
record with the blank field. Now run a query on the Physical file and check the
record.

Assuming that both are OK (i.e. there is a value in the field), then the problem
lies in the program that is processing the file.

A small point (semantics) - this logical is not joining two files, it specifies 
a
union between the two files (a merge). :-)

HTH

Paul Tuohy

Scott.Wolf@helpsystems.com wrote:

> I'm a newbie to RPG/400 and have learned much from this mailing list.
>
> I do have a question to offer up to all the gurus.
>
> I have a multi record format logical file that I am using. (see below)
>
> A          R WUDEPT                    PFILE(WUDPTP)
> A          K DEPT
> A          R STMASTF                   PFILE(WUSTDP)
> A          K SDEPT
> A          K STUNO
>
> The issue I'm having is on the first read through the file(s)
> one of the fields is coming up with no value, even though it should
> contain one.  Every other read is fine.
>
> I would like to be able to see how the logical is retrieving the
> information from the joined files.
>
> I can't use CPYF to print because of the multiple formats.
>
> Is there any other way I can dump the contents to see why that
> field is that way?
>
> Thanks for the help.
>
> Regards,
>
> Scott Wolf
> Technical Support
> tel     952.933.0609 x3377
> fax     952.238.8414
> email   scott.wolf@helpsystems.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
> +---

+---
| 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
+---