Re: MAPICS-L Digest, Vol 7, Issue 112 -- MAPICS-L

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@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of
mapics-l-request@xxxxxxxxxxxx
Sent: Monday, July 20, 2009 10:55 AM
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS-L Digest, Vol 7, Issue 112

Send MAPICS-L mailing list submissions to
mapics-l@xxxxxxxxxxxx

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@xxxxxxxxxxxx

You can reach the person managing the list at
mapics-l-owner@xxxxxxxxxxxx

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" <dave@xxxxxxxxxxxxxxx>
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)

dave@xxxxxxxxxxxxxxx
www.daveturbide.com <http://www.daveturbide.com/>

------------------------------

message: 2
date: Mon, 20 Jul 2009 09:23:14 -0400
from: "John Furniss" <JFurniss@xxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxx

------------------------------

message: 3
date: Mon, 20 Jul 2009 10:24:51 -0400
from: "Dave Shaw" <daveshaw@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
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@xxxxxxxxxxxx>
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@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
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?

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@xxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxx

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxx

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
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.

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@xxxxxxxxxxxxxxxxx

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
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