INTERVAL

The INTERVAL option allows you to unload a sample of data, rather than all rows that meet the selection criteria.

Related topic

Basic-processing-options


INTERVAL.png

The default is INTERVAL 0. The INTERVAL integer defines the interval of the selected rows that UNLOAD PLUS unloads. For example, INTERVAL 10 means that UNLOAD PLUS unloads every tenth row that it selects from each table or partition of the table space.

Important

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

 

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