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 | |
Multiple unloads in a single job step
The following are the two ways you can have multiple unloads in a single job step:
- (Recommended) Have multiple UNLOAD statements in your SYSIN. Each can specify their own SYSREC.
- Have one UNLOAD statement with multiple SELECT clauses. This restricts those unloads to sharing the parameters on the unload statement. BMC AMI Unload converts this syntax to multiple unload statements for processing. See the following sections to know about how to manage the SYSRECs.
You can use multiple SELECT statements to unload columns. For more information about SELECT statements, see SELECT.
To use multiple SELECT statements, specify UNLOAD UNLOADDN UNLOADDNPFX before the first SELECT statement. Use the UNLOADDN option to define the prefix of the ddname (the stock ddname) for the unload data sets. For example, if you specify UNLOADDN MYDD, the stock ddname will be MYDD. The stock ddname:
- Must not end with a number
- Must not exceed seven characters
- Should leave enough space for the SELECT statement numbers
The unload data sets must exist in either allocated DD statements in the JCL or in OUTPUT statements. Unload data sets that are specified in the JCL override those that are defined in OUTPUT statements.
The order of the SELECT statement determines the DD that BMC AMI Unload will use. For example, if you specify UNLOADDN UNLOAD UNLOADDNPFX, the first SELECT statement attempts to use UNLOAD1. If UNLOAD1 is unavailable, the statement attempts to use UNLOAD (the stock ddname). Likewise, the second SELECT statement attempts to use UNLOAD2. If UNLOAD2 is unavailable, the statement attempts to use the UNLOAD.
If you include PART or OPTIONS(PART) options with multiple SELECT statements, ensure that the DSNAME option on the OUTPUT command contains the &PART or &PARTn symbolic parameter. For more information, please see OUTPUT-syntax-options-common-to-disk-and-tape-data-sets.
Examples
When you specify multiple SELECT statements, BMC AMI Unload initially ignores the UNLOAD command but regenerates the command once for each SELECT statement. BMC AMI Unload then displays the UNLOAD commands to message NGTU293. If you also specify PART or OPTIONS(PART), BMC AMI Unload will regenerate the UNLOAD command. In this case, you can identify the PART regeneration in message NGTU293.
Sample messages
In the following sample:
- UNLOADDN specifies the stock ddname ULD.
- The stock ddname is used in the third SELECT statement.
NGTU293 UNLOAD UNLOADDN ULD1 UNLOADDNPFX SELNUM(0001) SELECT I1 FROM
NGTU293 MVSDSK1.INDSNTB WHERE I1 = 1000000 ;
NGTU293 COMMAND REGENERATED BY MULTIPLE SELECT
NGTU293 UNLOAD UNLOADDN ULD2 UNLOADDNPFX SELNUM(0002) SELECT B FROM
NGTU293 MVSDSK1.INDSNTB WHERE I1 = 2000000 ;
NGTU293 COMMAND REGENERATED BY MULTIPLE SELECT
NGTU293 UNLOAD UNLOADDN ULD UNLOADDNPFX SELNUM(0003) SELECT * FROM
NGTU293 MVSDSK1.INDSNTB WHERE I1 = 3000000 ;
Restrictions
For restrictions that apply to using the SELECT option, see SELECT.
Related topic