Limited supportBMC 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.

USELRECL

You can specify the USELRECL option to tell UNLOAD PLUS how to determine the record length.

USELRECL.png

Specifying the default

You can specify the default for the USELRECL command option in your installation options module by using the USELRECL installation option. UNLOAD PLUS was shipped with a default value of NO for this option. The command option overrides the default that is in the installation options module.

NO

Specify USELRECL NO to have UNLOAD PLUS use the record length that it calculates instead of one of the specified LRECL values.

YES

When you specify USELRECL YES, UNLOAD PLUS:

  • Checks and uses one of the following values:
    • The logical record length (LRECL) value in the data control block (DCB) for the primary unload data set DD statement in your JCL (that is, SYSREC)
    • The LRECL option specified on the OUTPUT statement that corresponds to each SELECT statement.

  • Uses fixed block format for the data set records and pads the records with spaces of the appropriate encoding scheme when necessary

    Important

    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.

  • Forces the same DCB values in the corresponding secondary unload data set (SYSRED)

  • Calculates the LRECL if you did not specify an LRECL value on the DD statement or in your OUTPUT statement

    If UNLOAD PLUS calculates the LRECL because you did not specify one in your JCL DD statement, the data set will be fixed, variable, or variable-spanned, according to the standard record length and record format calculations for UNLOAD PLUS.

Restrictions

Note the following restrictions on USELRECL YES:

  • If the specified LRECL is shorter than the length that is required to contain the largest formatted row, UNLOAD PLUS ends with error message BMC51649E.
  • UNLOAD PLUS ignores USELRECL YES if you specify any of the following options:
    • FORMAT CSV
    • FORMAT XML
    • FORMAT INTERNAL
    • FORMAT BMCLOAD
  • If you are unloading LOB or XML data, UNLOAD PLUS ignores this option for any referenced files that it allocates.

Related topic

Basic-processing-options

 

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