Default: 0 (No records are skipped.)
Purpose
The SKIP parameter specifies the number of logical records from the beginning of the file that should not be loaded. This allows you to continue loads that have been interrupted for some reason, without loading records that have already been processed.
Syntax and Description
SKIP=n
The SKIP parameter can be used for all conventional loads, for single-table direct path loads, and for multiple-table direct path loads when the same number of records was loaded into each table. It cannot be used for multiple-table direct path loads when a different number of records was loaded into each table.
If a WHEN clause is also present and the load involves secondary data, then the secondary data is skipped only if the WHEN clause succeeds for the record in the primary data file.
Restrictions
The SKIP parameter cannot be used for external table loads.
Example
The following example skips the first 500 logical records in the data file(s) before proceeding with the load:
SKIP=500