Re: AS/400 Client Access Problem

[rhamberg@xxxxxxxxxxxxxxxxxx]

     We have requests from our accounting department for various reports to be
used in EXCEL. her is a sample clp
     we use.

                    PGM        /*  COPY SPOOL FILES FOR DOWNLOAD */


/*********************************************************************/
                        CPYSPLF    ??FILE(SPC11X8@) TOFILE(REPORTS/MATASBER) +


??JOB(000000/HMATEUS/FILENAME) +
                                               ??SPLNBR(*LAST) ??TOMBR(R344BMP)
+
                                         CTLCHAR(*FCFC)

                ENDPGM

                ****************** End of data
****************************************
     In this sample, a lib call MATASBER is created with member names for the
reports to be downloaded, and the
     clp prompts for the rewuired info. the accounting staff then copies the
data to EXCEL. Hope this helps.

     R. Hamberg
     rhamberg@mother-parkers.com


+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---