INTERVAL

Use the INTERVAL option to indicate the sample frequency for the rows to be unloaded during the select.

INTERVAL
This parameter directs Optimâ„¢ High Performance Unload to unload 1 row every nn rows. For example, nn-1 rows are skipped as rows are unloaded.
Syntax
INTERVAL nn
Variable
Integer value.
Default
None.