BULKUNLOAD= LIBNAME Option

Rapidly retrieves (fetches) a large number of rows from a data set.
Valid in: SAS/ACCESS LIBNAME statement
Default: NO
Data source: Netezza
See: BULKUNLOAD= data set option, BULKLOAD= LIBNAME option, Netezza bulk unloading

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.