MaxRows option
Specifies to stop processing after an initial number of rows. Use a limit clause with the SELECT statement to limit loading data. The default is 0 (load all rows).
After processing
a row (whether inserting it, skipping it, or rejecting it), the system
uses
these guidelines to look for another input row:
- If you did not specify the MaxRows option, the system attempts to locate the next input row.
- If you specified the MaxRows option and the input row counter is equal to the MaxRows count, the system ends the load and commits all inserted records, not including the rows that were processed in the skipped row range. Otherwise, the system attempts to locate the next input row.