Hi,
I would like to know if there is an utility to can see the parameter of jobs scheduled in AJF of for example, all memname that beginning by 'los*'.
That is possible?
Many thanks and sorry for my english!
utility to see the parameters of AJF
Hi,
I see only one SQL query for this.
If these are the definitions for AUTOEDIT variables used in your active jobs (AJF) try one query like this:
select distinct substr(a.SCHEDTAB,1,20) as "SchedTab",
substr(a.JOBNAME,1,20) as "Jobname",
substr(a.MEMNAME,1,20) as "Memname",
substr(b.VAREXPR,1,80) as "Autoedit PARM"
from CMR_AJF a, CMR_SETVAR b where a.ORDERNO = b.ORDERNO and MEMNAME like 'your_memname';
I see only one SQL query for this.
If these are the definitions for AUTOEDIT variables used in your active jobs (AJF) try one query like this:
select distinct substr(a.SCHEDTAB,1,20) as "SchedTab",
substr(a.JOBNAME,1,20) as "Jobname",
substr(a.MEMNAME,1,20) as "Memname",
substr(b.VAREXPR,1,80) as "Autoedit PARM"
from CMR_AJF a, CMR_SETVAR b where a.ORDERNO = b.ORDERNO and MEMNAME like 'your_memname';
Best regards
Walty
Walty