RE: AS/400 Report Writers

["Stauch, Richard A" <richard.stauch@xxxxxxx>]

You've got the idea. The way we have handled these sorts of questions is in
the Initial Program To Call parameter (INLPGM) in the user profile. That
wouldn't work, though, for submitted jobs (setting the USER parameter on
SBMJOB command still won't run the INLPGM for that USER). Most jobs
submitted around here already have a CL shell program to call a validation
routine (also in CL), so your idea would be very appropriate there, for
submitted jobs [the status (Batch or Interactive) of a job can be checked
within CL, too].

Richard Allan Stauch
System Engineer, EDS
*       (562) 809-4861 (Voice)
*       (562) 860-8506 (Fax)
*       richard.stauch@eds.com (E-mail)


-----Original Message-----
From: gmihajlo@ssax.com [mailto:gmihajlo@ssax.com]
Sent: Tuesday, May 09, 2000 11:37 AM
To: BPCS-L@midrange.com
Subject: RE: AS/400 Report Writers


Talking about the system value QQRYTIMLMT, rather than changing it, in many
cases it might be more beneficial if similar value is defined at the job
level
by using command CHGQRYA (Change Query Attributes) and specifying
appropriate
value for parameter QRYTIMLMT (Query Time Limit), which will affect only
specified job instead of whole system.
[Snip]
SBMJOB CMD(CALL PGM(PGM123B))

where PGM123B is a RPG program which contains long running query, you would
do

SBMJOB CMD(CALL PGM(PGM123C))

where PGM123C would be a new CL program which does something like:

PGM
CHGQRYA QRYTIMLMT(15)
CALL PGM(PGM123B)
SBMJOB
ENDPGM

Goran
[Snip]
+---
| 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
+---