MAXROWS
Use the MAXROWS option to specify an upper limit for the number of rows to be unloaded.
- MAXROWS
- It is possible to extract from a given table a subset only of the rows it contains. The rows extraction is stopped when the number of rows unloaded has reached, or is about to reach, the limit set.
- When this option is specified, if there are only local database partitions to be
processed, the number of rows extracted is equal to the value set to it. If there are remote
database partitions, the number of rows extracted is less than or equal to this value.
- Syntax
- MAXROWS nn
- Variable
- Integer value.
- Default
- No default value.