Re: MAPICS-L Digest, Vol 7, Issue 112
"Thibault, Roland" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
The easiest way would be to put the CPYSPLF in the CL that runs the program to create the report. That way you could use the default of * for current job. Assuming that you're trying to get the report that was created by another job. Then you could use the command WRKOUTQ xxxx OUTPUT(*PRINT), then copy that spool file to a data file, and read thru that file to find the file name and job parms needed to copy the report to a database file. Roland Thibault -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of mapics-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] Sent: Monday, July 20, 2009 10:55 AM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: MAPICS-L Digest, Vol 7, Issue 112 Send MAPICS-L mailing list submissions to mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/mapics-l or, via email, send a message with subject or body 'help' to mapics-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] You can reach the person managing the list at mapics-l-owner-Zwy7GipZuJhWk0Htik3J/[email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of MAPICS-L digest..." Today's Topics: 1. Tom Glaza (Dave Turbide) 2. CPYSPLF from batch job (John Furniss) 3. Re: CPYSPLF from batch job (Dave Shaw) 4. Re: CPYSPLF from batch job (John Furniss) 5. Re: CPYSPLF from batch job (Gindlesperger, Dale) 6. Re: CPYSPLF from batch job (Dave Shaw) 7. Re: CPYSPLF from batch job (John Furniss) 8. Re: CPYSPLF from batch job (John Furniss) 9. Re: CPYSPLF from batch job (Dave Shaw) ---------------------------------------------------------------------- message: 1 date: Mon, 20 Jul 2009 09:03:28 -0400 from: "Dave Turbide" <[email protected]> subject: [MAPICS-L] Tom Glaza It is my sad duty to pass on the news that Tom Glaza has passed away. Tom was one of the driving forces behind the initial development and release of MAPICS within IBM in the 1970s. When Tom and some colleagues observed that the growing MAPICS user community needed education and support, Tom, Neville May, Bill Metzger and John Diak started GMD Systems which quickly became the leading MAPICS support organization at that time and since. GMD developed and delivered a full range of courseware covering the entire MAPICS range of function plus technical underpinnings and general management concerns. In addition, MAPICS affiliates (19 "master agents" and their organizations) covered the U.S. and a number of other affiliates delivered education, services and software in Europe and elsewhere around the world. GMD developed and/or acquired a number of software enhancements including several that became a part of MAPICS in subsequect releases including Purchasing, Stock Location and Lot Management (SLALOM), "process" enhancement (decimal precision and batch bills) and more. GMD played a key role in the development of MAPICS II and Tom continued his involvement as head of marketing when MAPICS was spun off by IBM and acquired by Marcam. Tom has been retired for a while and has been fighting cancer for the last several years. His strength and positive attitude during this time have been truly inspirational. I will miss him. For those of you in the Atlanta area, there will be a memorial service next Saturday July 25, at 10:00 AM at: St. Aidan's Episcopal Church 13560 Cogburn Road Alpharetta, GA 30004 Dave Turbide, CFPIM, CMfgE, CIRM (603) 964-6903 (office) (603) 401-0192 (cell) [email protected] www.daveturbide.com <http://www.daveturbide.com/> ------------------------------ message: 2 date: Mon, 20 Jul 2009 09:23:14 -0400 from: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> subject: [MAPICS-L] CPYSPLF from batch job Hello List: I am needing to copy the Mapics Open Orders/Back Orders by Item report (spool file name AMBDZPFP) to a physical file. I then run the PF through an RPGLE program to replace the report date in the header to reflect the date the actual data is for. The CPYSPLF command requires job name, user and number of the spool file being copied. My problem is that the report gets submitted to a random batch job so I have no way of finding the job name or number. Has anyone done something similar? Is there a Mapics report override that will help me? Any help is greatly appreciated. Thanks, John Furniss Applications Programmer Allied Machine & Engineering, Corp Phone: 330-343-4283, ext. 8371 email: jfurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected] ------------------------------ message: 3 date: Mon, 20 Jul 2009 10:24:51 -0400 from: "Dave Shaw" <[email protected]> subject: Re: [MAPICS-L] CPYSPLF from batch job John, All you need is this command: RTVJOBA JOB(&JOB) USER(&USER) NBR(&NBR) Dave Shaw MAPICS-L moderator ----- Original Message ----- From: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> To: "MAPICS ERP System Discussion" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> Sent: Monday, July 20, 2009 9:23 AM Subject: [MAPICS-L] CPYSPLF from batch job > Hello List: > > > > I am needing to copy the Mapics Open Orders/Back Orders by Item report > (spool file name AMBDZPFP) to a physical file. I then run the PF through > an RPGLE program to replace the report date in the header to reflect the > date the actual data is for. > > > > The CPYSPLF command requires job name, user and number of the spool file > being copied. My problem is that the report gets submitted to a random > batch job so I have no way of finding the job name or number. > > > > Has anyone done something similar? Is there a Mapics report override > that will help me? ------------------------------ message: 4 date: Mon, 20 Jul 2009 10:34:18 -0400 from: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> subject: Re: [MAPICS-L] CPYSPLF from batch job Dave, Yes, but WHERE do I put this command? It needs to go in the batch job because the batch job is different from my interactive job that submitted it. John Furniss Applications Programmer Allied Machine & Engineering, Corp Phone: 330-343-4283, ext. 8371 email: jfurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected] -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Dave Shaw Sent: Monday, July 20, 2009 10:25 AM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] CPYSPLF from batch job John, All you need is this command: RTVJOBA JOB(&JOB) USER(&USER) NBR(&NBR) Dave Shaw MAPICS-L moderator ----- Original Message ----- From: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> To: "MAPICS ERP System Discussion" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> Sent: Monday, July 20, 2009 9:23 AM Subject: [MAPICS-L] CPYSPLF from batch job > Hello List: > > > > I am needing to copy the Mapics Open Orders/Back Orders by Item report > (spool file name AMBDZPFP) to a physical file. I then run the PF through > an RPGLE program to replace the report date in the header to reflect the > date the actual data is for. > > > > The CPYSPLF command requires job name, user and number of the spool file > being copied. My problem is that the report gets submitted to a random > batch job so I have no way of finding the job name or number. > > > > Has anyone done something similar? Is there a Mapics report override > that will help me? _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 5 date: Mon, 20 Jul 2009 10:40:25 -0400 from: "Gindlesperger, Dale" <DGindle-mOOO9ZFGm7dWk0Htik3J/[email protected]> subject: Re: [MAPICS-L] CPYSPLF from batch job John, Will you want to do this process every time the report is run? Dale "Cork" Gindlesperger, CPIM Senior Business Analyst -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of John Furniss Sent: Monday, July 20, 2009 10:34 AM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] CPYSPLF from batch job Dave, Yes, but WHERE do I put this command? It needs to go in the batch job because the batch job is different from my interactive job that submitted it. John Furniss Applications Programmer Allied Machine & Engineering, Corp Phone: 330-343-4283, ext. 8371 email: jfurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected] -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Dave Shaw Sent: Monday, July 20, 2009 10:25 AM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] CPYSPLF from batch job John, All you need is this command: RTVJOBA JOB(&JOB) USER(&USER) NBR(&NBR) Dave Shaw MAPICS-L moderator ----- Original Message ----- From: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> To: "MAPICS ERP System Discussion" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> Sent: Monday, July 20, 2009 9:23 AM Subject: [MAPICS-L] CPYSPLF from batch job > Hello List: > > > > I am needing to copy the Mapics Open Orders/Back Orders by Item report > (spool file name AMBDZPFP) to a physical file. I then run the PF through > an RPGLE program to replace the report date in the header to reflect the > date the actual data is for. > > > > The CPYSPLF command requires job name, user and number of the spool file > being copied. My problem is that the report gets submitted to a random > batch job so I have no way of finding the job name or number. > > > > Has anyone done something similar? Is there a Mapics report override > that will help me? _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 6 date: Mon, 20 Jul 2009 10:41:57 -0400 from: "Dave Shaw" <[email protected]> subject: Re: [MAPICS-L] CPYSPLF from batch job John, Maybe I misunderstood. Where are you doing the CPYSPLF? In the batch job, or in another job? Dave Shaw MAPICS-L moderator ----- Original Message ----- From: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> To: "MAPICS ERP System Discussion" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> Sent: Monday, July 20, 2009 10:34 AM Subject: Re: [MAPICS-L] CPYSPLF from batch job > Dave, > > Yes, but WHERE do I put this command? It needs to go in the batch job > because the batch job is different from my interactive job that > submitted it. ------------------------------ message: 7 date: Mon, 20 Jul 2009 10:43:25 -0400 from: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> subject: Re: [MAPICS-L] CPYSPLF from batch job Dale, Yes, we want this every time the report is run. John Furniss Applications Programmer Allied Machine & Engineering, Corp Phone: 330-343-4283, ext. 8371 email: jfurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected] -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Gindlesperger, Dale Sent: Monday, July 20, 2009 10:40 AM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] CPYSPLF from batch job John, Will you want to do this process every time the report is run? Dale "Cork" Gindlesperger, CPIM Senior Business Analyst -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of John Furniss Sent: Monday, July 20, 2009 10:34 AM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] CPYSPLF from batch job Dave, Yes, but WHERE do I put this command? It needs to go in the batch job because the batch job is different from my interactive job that submitted it. John Furniss Applications Programmer Allied Machine & Engineering, Corp Phone: 330-343-4283, ext. 8371 email: jfurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected] -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Dave Shaw Sent: Monday, July 20, 2009 10:25 AM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] CPYSPLF from batch job John, All you need is this command: RTVJOBA JOB(&JOB) USER(&USER) NBR(&NBR) Dave Shaw MAPICS-L moderator ----- Original Message ----- From: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> To: "MAPICS ERP System Discussion" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> Sent: Monday, July 20, 2009 9:23 AM Subject: [MAPICS-L] CPYSPLF from batch job > Hello List: > > > > I am needing to copy the Mapics Open Orders/Back Orders by Item report > (spool file name AMBDZPFP) to a physical file. I then run the PF through > an RPGLE program to replace the report date in the header to reflect the > date the actual data is for. > > > > The CPYSPLF command requires job name, user and number of the spool file > being copied. My problem is that the report gets submitted to a random > batch job so I have no way of finding the job name or number. > > > > Has anyone done something similar? Is there a Mapics report override > that will help me? _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 8 date: Mon, 20 Jul 2009 10:45:55 -0400 from: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> subject: Re: [MAPICS-L] CPYSPLF from batch job Dave, It doesn't matter to me which job I put the CPYSPLF in, but since I have no way of knowing what the batch job name and number will be, I would assume it would have to go in the batch job. Is it possible to modify the batch job that gets created for this report? John Furniss Applications Programmer Allied Machine & Engineering, Corp Phone: 330-343-4283, ext. 8371 email: jfurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected] -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Dave Shaw Sent: Monday, July 20, 2009 10:42 AM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] CPYSPLF from batch job John, Maybe I misunderstood. Where are you doing the CPYSPLF? In the batch job, or in another job? Dave Shaw MAPICS-L moderator ----- Original Message ----- From: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> To: "MAPICS ERP System Discussion" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> Sent: Monday, July 20, 2009 10:34 AM Subject: Re: [MAPICS-L] CPYSPLF from batch job > Dave, > > Yes, but WHERE do I put this command? It needs to go in the batch job > because the batch job is different from my interactive job that > submitted it. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 9 date: Mon, 20 Jul 2009 10:50:24 -0400 from: "Dave Shaw" <[email protected]> subject: Re: [MAPICS-L] CPYSPLF from batch job John, If you have a source license, you should have the source for the CL program that runs the report. If so, you can add the RTVJOBA and the CPYSPLF to it. Dave Shaw MAPICS-L moderator ----- Original Message ----- From: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> To: "MAPICS ERP System Discussion" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> Sent: Monday, July 20, 2009 10:45 AM Subject: Re: [MAPICS-L] CPYSPLF from batch job > Dave, > > It doesn't matter to me which job I put the CPYSPLF in, but since I have > no way of knowing what the batch job name and number will be, I would > assume it would have to go in the batch job. Is it possible to modify > the batch job that gets created for this report? > > John Furniss > Applications Programmer > Allied Machine & Engineering, Corp > Phone: 330-343-4283, ext. 8371 > email: jfurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected] > > -----Original Message----- > From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Dave Shaw > Sent: Monday, July 20, 2009 10:42 AM > To: MAPICS ERP System Discussion > Subject: Re: [MAPICS-L] CPYSPLF from batch job > > John, > > Maybe I misunderstood. Where are you doing the CPYSPLF? In the batch > job, > or in another job? > > Dave Shaw > MAPICS-L moderator > > ----- Original Message ----- > From: "John Furniss" <JFurniss-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> > To: "MAPICS ERP System Discussion" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> > Sent: Monday, July 20, 2009 10:34 AM > Subject: Re: [MAPICS-L] CPYSPLF from batch job > > >> Dave, >> >> Yes, but WHERE do I put this command? It needs to go in the batch job >> because the batch job is different from my interactive job that >> submitted it. > > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list > To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives > at http://archive.midrange.com/mapics-l. > > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list > To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives > at http://archive.midrange.com/mapics-l. > ------------------------------ _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) digest list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. End of MAPICS-L Digest, Vol 7, Issue 112 **************************************** *********************************************************************** This transmission contains information which may be confidential and which may also be privileged. It is intended for the named addressee only. Unless you are the named addressee, or authorized to receive it on behalf of the addressee you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please contact the sender. Thank you for your cooperation. *********************************************************************** For more information about QSA Global Inc. please visit our website at http://www.qsa-global.com _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.