If an EXEC statement calls a cataloged or in-stream procedure,
the TIME parameter is added to or overrides the TIME parameter on:
- The EXEC statement named in the procstepname qualifier. The information
applies only to the named procedure step. The EXEC statement can have
as many TIME.procstepname parameters as the procedure has steps;
each TIME parameter must specify a unique procstepname.
If procstepname is not coded, the TIME parameter applies to
the entire procedure and nullifies any TIME parameters on EXEC statements
in the procedure. For example, suppose you specify TIME=5 on an EXEC
statement that calls a procedure. The first step in the procedure
is allowed 5 minutes, the second step is allowed 5 minutes minus the
time used by the first step, the third step is allowed 5 minutes minus
the time used by the first and second steps, and so forth, regardless
of any TIME parameter values on EXEC statements in the procedure.
TIME=1440 and TIME=NOLIMIT also nullify any TIME parameters on
EXEC statements in the procedure. Specifying TIME=1440 or TIME=NOLIMIT
on the calling EXEC statement allows the procedure to have unlimited
processor time.