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.
Related topic
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.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*