Writer instructions | |
|---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines | |
DISCARDDN
The DISCARDDN option tells BMC AMI Reorg to write all deleted rows to a sequential file. If there are no discards, the file is not allocated.
ddname
Specify a valid DD name for this file. BMC AMI Reorg:
- Sets data control block characteristics internally
- Writes each deleted row as a separate record in the file
The default format is UNLOAD. This format is the same as the Db2 REORG UNLOAD format. It is suitable for loading into a similar table using the LOAD ... FORMAT UNLOAD statement.
A special case exists if BMC AMI Reorg discards rows due to a DISCARD specification, but neither the DISCARDDN option nor a SYSDISC DD is present. In this case, any discarded rows are permanently lost, regardless of whether you requested dynamic allocation or specified a discard data set. BMC AMI Reorg does not send the discarded rows to any data set and does not dynamically allocate any data set.
If you specify either SYSDISC or DISCARDDN, BMC AMI Reorg writes the discarded rows to the specified data set. If you specify DISCARDDN but a data set is not defined, BMC AMI Reorg dynamically allocates the data set by using one of the following methods. The value of the OVERRIDEOUTPUT parameter determines the method that BMC AMI Reorg uses.
The XULDDYNM-unload-data-set-and-discards-automation-control-point
In XULDDYNM, the dsname variable sets the data set name.
- The OUTPUT-command-for-BMC-AMI-ReorgYou must place the OUTPUT command before the REORG statement in your SYSIN.
If you specify a SYSDISC DD and the DISCARDDN option, BMC AMI Reorg writes the discarded rows only to the dynamically-allocated data set and not to any data set associated with the SYSDISC DD.
FORMAT
FORMAT specifies the format of the discard data. You must specify DISCARDDN to use this option. If you do not specify a format, the default format is UNLOAD.
If FORMAT UNLOAD is in effect, BMC AMI Reorg does not write generated LOAD statements to SYSPUNCH.
DSNTIAUL | Uses the IBM Db2 internal format DSNTIAUL. You can abbreviate this as DSN. If you specify more than one table on a DISCARD clause, the output file will contain a 2-byte OBID value at the beginning of each row. If you specify only one table on a DISCARD clause, this 2-byte OBID will be absent. |
UNLOAD | (default) Uses the Db2 REORG UNLOAD format. You can abbreviate this as ULD. SYSPUNCH output will not be written if FORMAT UNLOAD is specified. |
EXTERNAL | Uses EXTERNAL format. You can abbreviate this as EXT. |
REPORT | Uses REPORT format. You can abbreviate this as REP. |
ASCIIDEL | Uses ASCIIDEL format (ASCII, with values delimited by double quotes). You can abbreviate this as ASC. |
PAD | (default) Pads VARCHAR columns to their full length. You cannot use PAD with the EXTERNAL, REPORT, ASCIIDEL formats. |
NOPAD | The NOPAD option will cause the output file not to pad VARCHAR columns to their full length—that is, to the actual length of the data only, minus any trailing blanks. NOPAD is not valid for the following formats: EXTERNAL, REPORT, ASCIIDEL. |
Related topics