Previous Page | Next Page

Data Set Options for Relational Databases

BULKEXTRACT= 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: HP Neoview

Syntax
Syntax Description
Details
See Also

Syntax

BULKEXTRACT=YES | NO

Syntax Description

YES

calls the HP Neoview Transporter to retrieve data from HP Neoview.

NO

uses standard HP Neoview result sets to retrieve data from HP Neoview.


Details

Using BULKEXTRACT=YES is the fastest way to retrieve large numbers of rows from an HP Neoview 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

Extracting

Previous Page | Next Page | Top of Page