Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

LRECL

LRECL specifies the logical record length to be used for any data set dynamically allocated with this output descriptor when you also specify USELRECL YES.

LRECL.png

If you specify USELRECL NO, the LRECL specification is ignored.

Restrictions

Note the following restrictions when specifying LRECL:

  • If the LRECL that you specify is shorter than the length that is required to contain the largest formatted row, UNLOAD PLUS ends with error message BMC51649E.
  • If you specify USELRECL YES with FORMAT CSV, FORMAT XML, FORMAT INTERNAL, or FORMAT BMCLOAD, UNLOAD PLUS ignores both USELRECL YES and LRECL.

Additional considerations

The following considerations apply to the LRECL option:

  • When you specify LRECL, UNLOAD PLUS normally defines the dynamically allocated data set with a fixed record format. However, if you specify RECFM VB on your UNLOAD command (or it is in effect by default from the RECFM installation option) UNLOAD PLUS uses variable block format for the data set records.
  • If you do not specify LRECL in your OUTPUT statement and you specify USELRECL YES, UNLOAD PLUS calculates the LRECL value. The associated data set will be fixed, variable, or variable-spanned, according to the standard record length and record format calculations for UNLOAD PLUS.

Related topic

Common-options-for-the-OUTPUT-command

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

UNLOAD PLUS for DB2 11.2