Previous Page | Next Page

Data Set Options for Relational Databases

BULKUNLOAD= Data Set Option



Rapidly retrieves (fetches) large number of rows from a data set.
Default value: NO
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: Netezza

Syntax
Syntax Description
Details
See Also

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.


See Also

To assign this option to a group of relational DBMS tables or views, see the BULKUNLOAD= LIBNAME Option.

BL_DATAFILE= Data Set Option

BL_DELETE_DATAFILE= Data Set Option

BL_DELIMITER= Data Set Option

BL_USE_PIPE= Data Set Option

BULKLOAD= Data Set Option

Unloading

Previous Page | Next Page | Top of Page