Specifies the reject limit count.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | none |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES and then specify BL_REJECT_TYPE=. |
| Interaction: | If the BL_EXCEPTION= data set option is not specified, then rejected records are dropped and are not saved to an exception table. |
| Data source: | Greenplum, HAWQ |
| See: | BL_EXCEPTION= data set option, BL_REJECT_TYPE= data set option, BULKLOAD= data set option |
Table of Contents
specifies the reject limit count either as a percentage (1 to 100) of total rows or as a number of rows.
When BL_REJECT_TYPE=PERCENT, the percentage of rows per segment is calculated based on the Greenplum database configuration parameter (gp_reject_percent_threshold). The default value for this parameter Greenplum parameter is 300.
Input rows with format errors are discarded if the reject limit count is not reached on any Greenplum segment instance during the load operation.
Constraint errors result when violations occur to such constraints as NOT NULL, CHECK, or UNIQUE. A single constraint error causes the entire external table operation to fail. If the reject limit is not reached, rows without errors are processed and rows with errors are discarded.