BULKUNLOAD= Data Set Option

Rapidly retrieves (fetches) large number of rows from a data set.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: NO
Data source: Netezza
See: BULKUNLOAD= LIBNAME option, BL_DATAFILE= data set option, BL_DELIMITER= data set option, BL_DELIMITER= data set option, BL_USE_PIPE= data set option, BULKLOAD= data set option, Bulk Unloading for Netezza

Syntax

BULKUNLOAD=YES | NO

Syntax Description

YES
calls the Netezza Remote External Table interface to retrieve data from the Netezza Performance Server.
NO
uses standard Netezza result sets to retrieve data from the DBMS.

Details

Using BULKUNLOAD=YES is the fastest way to retrieve large numbers of rows from a Netezza table.