OUTPUT keyword

The OUTPUT keyword specifies the format of the output file.

The OUTPUT keyword is an optional keyword for the FPXCTL statement of ODE. If this keyword is specified, it must be assigned an appropriate value.

Format:
Read syntax diagramSkip visual syntax diagramOUTPUT=STDDBTTFMTURUSER
STD (or S)
Standard extract format is to be used.
DBT (or D)
FPB Unload/Reload DBT format is to be used.
TFMT (or T)
FPB Unload/Reload TFMT format is to be used. The format of the unloaded segment records is enhanced, which means that the prefix part of the record is generated based on the maximum number of segment levels that are defined in DBD.
UR (or U)
TRIMAR unload/reload format is to be used.
USER
Allows more granular control of the output file. This format should be used when an existing application program requires extracted data in a specific format.
Note: If ODE is run by FPXIN DD, a DBD Control Information record is created for each output file. If ODE is run by SYSIN DD, the number of DBD Control Information records that are written to the output file is the same as the number of areas that are written to the file, and the records are written at the beginning of the output data of each area.
Default:
STD, if the OUTPUT keyword is not specified.
Site default support:
Supported.
Restrictions:
  • A specification of TFMT or UR is mutually exclusive with SORT=YES.
  • If OUTPUT=USER and SORT=YES are specified, SORT=YES is internally changed to SORT=NO.
  • If OUTPUT=DBT/TFMT/UR is specified, all segments in the hierarchic path, which includes the selected segment and all of its parent segments, must be selected for output.
  • The extraction of SDEP segments depends on the OUTPUT, SORT, and SDEPHIER specifications. The following table shows the SDEP segments extraction.
    Table 1. SDEP segments extraction
    OUTPUT SORT SDEPHIER SDEP segment extraction
    STD YES YES If ODESORT DD is specified, SDEP segments are extracted hierarchically. If ODESORT DD is not specified, ODE issues message FPX0002E and ends with an error.
    NO SDEP segments cannot be extracted.
    NO YES SDEP segments are extracted hierarchically.
    NO SDEP segments are extracted physically.
    DBT YES YES If ODESORT DD is specified, SDEP segments are extracted hierarchically. If ODESORT DD is not specified, ODE issues message FPX0002E and ends with an error.
    NO SDEP segments cannot be extracted.
    NO YES SDEP segments are extracted hierarchically.
    NO SDEP segments cannot be extracted.
    TFMT YES - Keyword error.
    NO YES Keyword error.
    NO SDEP segments cannot be extracted.
    UR YES - Keyword error.
    NO YES Keyword error.
    NO SDEP segments cannot be extracted.
    USER Yes - Internally changed to SORT=NO.
    NO YES SDEP segments are extracted hierarchically.
    NO SDEP segments are extracted physically.