RE: UNION FILES

yes I did just that ; a CPYF
>From file  . . . . . . . . . . . > TILSUBADD#
  Library  . . . . . . . . . . . >   TRNGQCF
To file  . . . . . . . . . . . . > TIPSUBADD
  Library  . . . . . . . . . . . >   HDBACMS
>From member  . . . . . . . . . . > *ALL
To member or label . . . . . . .   *FIRST
Replace or add records . . . . . > *REPLACE
Create file  . . . . . . . . . .   *NO
Print format . . . . . . . . . .   *CHAR

                           Additional Parameters

Record format of logical file  . > *ALL
Record format field mapping  . . > *NOCHK

BUT then the users are going to have to run an AS/400 program prior to the
crystal reports run and since they are managers they wont do that,
LOL

> -----Original Message-----
> From: Mike.Collins@syan.co.uk [SMTP:Mike.Collins@syan.co.uk]
> Sent: Thursday, April 18, 2002 9:36 AM
> To:   rpg400-l@midrange.com
> Subject:      RE: UNION FILES
>
>
> In that case, you may be forced to create a third file to which you copy
> the data from the other two files either via CPYF or SQL.
>
> _______________________________________________
> 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.