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.

ESTROWS

One of the methods that UNLOAD PLUS can use to calculate the size of the data sets that are produced during dynamic allocation is an ESTROWS number that you specify on a SELECT statement.

ESTROWS.png

The integer is the number of rows that you expect that UNLOAD PLUS will unload using that SELECT statement. See ANALYZE.

You must specify the ESTROWS, LIMIT, or SPACE command option to supply sizing information for dynamic allocation in either of the following cases:

  • DIRECT NO is in effect.
  • You specify INFILE.

If you are unloading LOB or XML data, UNLOAD PLUS ignores this option for any referenced files that it allocates.

Related topic

SELECT-options

 

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