Re: CPYSPLF from batch job

Hi Jhon!

    You have control of the MAPICS Jobs in JOBACT *PF , Exemplo from control  job (In Sqlrpgle ) from production bacth where AMIPEB is a programm mapics to execute, this a user and job number.

Select ACREC,JAUSR,T,JBREF,JAJNR,JQUE1                              
>From (                                                              
Select ACREC,JAUSR,Char(DTIME) As T,JBREF,JQUE1,JAJNR,PROCX,        
       Substr(LDABS,110,6) As LOT                                   
>From JOBACT06                                                       
) As Tab01                                                          
Where PROCX='AMIPEB' And LOT='AMIPEA'                               
Order by T                                                          

Where ACREC is  A = Active and Q = In Queue

Best Regards!

Luis Saenz

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

Core do Brasil Ltda
http://www.coredobrasil.com.br
Phone +55 11  3711-8328
São Paulo, Brasil



----- 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: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?
> 
> 
> 
> 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]
> 
> 
> 
> _______________________________________________
> 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.