Symbolic substitutions
You can use these symbolic names with
Log Master
syntax or the online interface as indicated. When your job runs,
Log Master
replaces the symbolic name with the corresponding generated data.
The following table shows a list of symbolic substitutions.
Substitution | Description | Input data set names | Input member name | Input log mark names | Output data set names | Output member names | Output log mark names | Output image copy for each partition |
|---|---|---|---|---|---|---|---|---|
&DATE | Current date (yymmdd) | NO | NO | NO | YES | YES | YES | YES |
&DBNAME | Database name of the current table space (for load separate data sets output only) | NO | NO | NO | YES | NO | NO | YES |
&DBID | DBID of the current table or table space (for load separate data sets output only) | NO | NO | NO | YES | NO | NO | NO |
&DSNUM | The partition number or data set number of the current table space (for DROPRECOVERY OUTPUT data set names) | NO | NO | NO | NO | NO | NO | YES 1 |
&GATN | Current group attachment name | YES | YES | YES | YES | YES | YES | YES |
&JOBNAME | Batch job name | NO | NO | YES | YES | YES | YES | YES |
&OBID | OBID of the current table (for load separate data sets output only) | NO | NO | NO | YES | NO | NO | NO |
&PSID | PSID of the current table space (for load separate data sets output only) | NO | NO | NO | YES | NO | NO | NO |
&RPTTYPE | Type of report being generated, for example, AUDIT (for output report data sets only) | NO | NO | NO | YES | YES | NO | NO |
&SSID | Current Db2 subsystem ID | YES | YES | YES | YES | YES | YES | YES |
&SYSUID | User ID associated with batch job | YES | YES | YES | YES | YES | YES | YES |
&TABNAME | Name of the current table (for load separate data sets output only) | NO | NO | NO | YES | NO | NO | NO |
&TABOWN | Creator of the current table (for load separate data sets output only) | NO | NO | NO | YES | NO | NO | NO |
&TIME | Current time (hhmmss) | NO | NO | NO | YES | YES | YES | YES |
&TSNAME | Name of the current table space (for load separate data sets output only) | NO | NO | NO | YES | NO | NO | YES |
&WORKID | Name portion of the work ID | YES | NO | YES | YES | NO | YES | NO |
&WORKUSR | User ID portion of the work ID | YES | YES | YES | YES | YES | YES | NO |
&ZPREFIX | TSO prefix as defined in TSO profile | YES | YES | YES | YES | YES | YES | NO |
1 &DSNUM is required to create an output image copy for each table space partition.
This section contains the following topics: