Symbolic substitutions
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:
Comments
Log in or register to comment.