Re: UNION FILES

[David & Eileen Keck <bstars@xxxxxxxxxxxxx>]

Dean,  Just a couple of notes ...
1. There is no UNION DDS keyword, UNION is an SQL verb used to merge two or
more PF's into a single new PF.
2. You can use the JOIN DDS keyword to create an LF that merges the two or
more PF's
3. PF's are not able to have more than one record format.
4. The code you provided creates two LF's ... not a single merged view of
any kind.
5. The 4th field defined in your LF's has a different name in each file
(typo) ?
Could you clarify some what you are doing base on the above.  Thanks - Dave
K.

----- Original Message -----
> Good Morning All, I have to create a logical file (UNION over two PF's
with
> different record formats.) The PF's that this is to be built over have
only
> one record format apiece. My problem is that crystal reports is having a
> hard time seeing this file and the file itself doesnt seem to have the
total
> records of BOTH based on PF's. I created the file as follows; Does anyone
> have any insights on this matter. I know I cant create a Union LF that has
> only one rec format, at least I think thats the case, LOL. Gads its
> earlyyyy. Thanks all, code is below.
>
>   * SUBSCRIBER (MAIN) FILE
>  A          R TIFSUBS                   PFILE(TIPSUBS)
>  A            SBSUB#
>  A            SBNPA
>  A            SBNXX
>  A            SBLIN
>  A            SBDISD
>  A            SBTERM
>  A            SBLIST
>  A            SBPMTD
>  A            SBMTYP
>   *
>  A          K SBSUB#
>  A          K SBNPA
>  A          K SBNXX
>  A          K SBLIN
>   *
>   * +-------------------------------------------------------------
>   *
>   * ADDITIONAL NUMBER FILE
>   *
>  A          R TIFADD#                   PFILE(TIPADD#)
>  A            ADSUB#
>  A            ADNPA
>   A            ADNXX
>   A            ADLINE
>   A            ADDISD
>   A            ADTERM
>   A            ADLIST
>   A            ADPMTD
>   A            ADMTYP
>    *
>   A          K ADSUB#
>   A          K ADNPA
>   A          K ADNXX
>   A          K ADLINE
>    *