Data Set Options for Relational Databases |
Specifies the reject limit count.
Default value: |
none
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Greenplum
|
- number
-
specifies the reject limit count either as a percentage
(1 to 99) of total rows or as a number of rows.
To specify this option, you must first set BULKLOAD=YES
and then set BL_REJECT_TYPE=.
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 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.
BL_REJECT_TYPE= Data Set Option
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.