RE: UNION FILES

[Dean Bathke <dbathke@xxxxxxxxxxxx>]

that seems reasonable. the thing I guess shes having problems with is the
fact that there are additional files as well. for example
A list reads each cable pair in OPPCBPR then goes to OPPDUZ to get the phone
number and then on to tipsubs or tipadd to find the info. If you could send
a a statement Im sure Carrie couldnt figure out the remainder. its the union
portion shes having trouble with
Thanks alot


> -----Original Message-----
> From: David Morris [SMTP:David.Morris@plumcreek.com]
> Sent: Thursday, April 18, 2002 9:38 AM
> To:   rpg400-l@midrange.com
> Subject:      Re: UNION FILES
>
> Doesn't crystal reports use SQL for its access? It would seem you could
> use
> a union in the SQL statement or at least a left outer join combined
> with an
> exception join. If that seems reasonable, I could post a statement
> based
> on your DDS.
>
> David Morris
>
> >>> dbathke@Quintrex.com 04/18/02 07:09AM >>>
> 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
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.