The selection control statement, SEL, contains selection parameters that specify on which tables, job scheduling definitions, applications, groups, and rule-based calendars the utility is to operate. If no SEL statement is coded, then no updates are made to the job scheduling library. The following is the format for the selection control statement:
SEL [TBL=tbl_name][,JOB=job_name][,APPL=app_name]
[,GRP=grp_name][,RBC=sched_rbc][,SCOPE=ALL|FIRST]
where
tbl_name specifies the tables in the scheduling library to be selected.
job_name specifies the job scheduling definitions in the tables to be selected.
This parameter must match the value of the MEMNAME parameter in the job scheduling definition.
app_name specifies the applications to be selected.
This parameter must match the value of the APPL parameter in the job scheduling definition.
grp_name specifies the groups to be selected.
This parameter must match the value of the GROUP parameter in the job scheduling definition.
sched_rbc specifies the rule-based calendars to be selected.
This parameter must match the value of the SCHEDULE RBC parameter in the SMART Table Entity scheduling definition.
SCOPE indicates which rule-based calendars to update according to the specified sched_rbc:
ALL matching RBCs
FIRST matching RBC (default)
The selection control statement must precede all update parameters, begin in column 1, and be entirely contained in one record. Note the following points:
You can specify any, all, or none of these parameters in any order in the SEL statement.
Note: If you do not specify any parameters, subsequent update parameters will modify every job in each table in the scheduling library.
Each parameter can appear no more than one time in any SEL statement, and it can have no more than one value assigned to it. Prefix values can be specified by placing an asterisk at the end of the value string. For more information, see CTMTBUPD Utility Control Statements.
When multiple parameters are specified, they are connected by an implicit logical AND relationship.
When parameter RBC is specified, only basic scheduling parameters (DAYS, WDAYS, and so on.) in rule-based calendars of SMART Table Entities are processed. Only the first matching rule-based calendar in a SMART Table Entity is processed. The rule-based calendar name itself can be changed.
To exclude modifications to SMART Table Entity fields, specify parameter JOB.
A selection group consists of a SEL statement, followed by associated update parameters, and closed by an ENDSEL statement. You can include multiple SEL blocks in a single execution of the CTMTBUPD utility.
Note: To improve performance when multiple SEL/ENDSEL blocks are coded, group the SEL/ENDSEL blocks so that all updates to the same table members are executed consecutively.