BL_REJECT_TYPE= Data Set Option

Indicates whether the reject limit count is a number of rows or a percentage of total rows.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Set Control
Default: ROWS
Requirement: To specify this option, you must first specify BULKLOAD=YES.
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_REJECT_LIMIT= data set option, BULKLOAD= data set option

Table of Contents

Syntax

BL_REJECT_TYPE=ROWS | PERCENT

Syntax Description

ROWS

specifies the reject limit count as a number of rows.

PERCENT

specifies the reject limit count as a percentage of total rows. Valid values range from 1 to 100.

Last updated: February 3, 2026