LIMIT

The LIMIT option defines the limit on the number of rows that UNLOAD PLUS selects from each table or partition of the table space.

Related topic

Basic-processing-options

LIMIT.png

The default is LIMIT 0 (no limit). If UNLOAD PLUS reaches the limit, it ends normally.

Additional information

Note the following additional information about this option:

  • When unloading from a partitioned table space using DIRECT NO, LIMIT functions as if the table space were nonpartitioned.

  • When you are dynamically allocating output data sets, you must also specify the LIMIT, ESTROWS, or SPACE command option in either of the following cases:

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

    When you are dynamically allocating output data sets, the LIMIT keyword tells UNLOAD PLUS to derive the total number of records per data set and calculate the data set size and space needed for allocating the data sets.

 

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