Default: All records are loaded.
LOAD parameter specifies the maximum number of records to load.
Syntax and Description
If you want to test that all parameters you have specified for the load are set correctly, you can use the
LOAD parameter to specify a limited number of records rather than loading all records. No error occurs if fewer than the maximum number of records are found.
The following example specifies that a maximum of 10 records be loaded.
For external tables method loads, only successfully loaded records are counted toward the total. So if there are 15 records in the input data file and records 2 and 4 are bad, then the following records are loaded into the table, for a total of 10 records - 1, 3, 5, 6, 7, 8, 9, 10, 11, and 12.
For conventional and direct path loads, both successful and unsuccessful load attempts are counted toward the total. So if there are 15 records in the input data file and records 2 and 4 are bad, then only the following 8 records are actually loaded into the table - 1, 3, 5, 6, 7, 8, 9, and 10.