 |
|
| 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_DELETE_DATAFILE= Data Set Option
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.