Data Set Options for Relational Databases |
Specifies
a named pipe for data transfer.
Default value: |
DBMS-specific
|
Restriction: |
Not available for Oracle on z/OS
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
HP Neoview, Netezza, Oracle, Sybase IQ
|
- YES
-
specifies that a named pipe is used to transfer data between SAS/ACCESS interfaces
and the DBMS client interface.
- NO
-
specifies that a flat file is used to transfer data.
By default, the DBMS interface uses a named pipe interface
to transfer large amounts of data between SAS and the DBMS when using bulk
load or bulk unload. If you prefer to use a flat data file that you can save
for later use or examination, specify BL_USE_PIPE=NO.
HP Neoview: To specify this option, you must first set
BULKEXTRACT=YES. This option determines how to the sources section of the
control file are set up and the method that is used to transfer or receive
data from the HP Neoview Transporter. In particular, its setting helps you
choose which specific source to select. The default value is YES.
Netezza: To specify this option, you must first set BULKLOAD=YES
or BULKUNLOAD=YES. The default value is YES.
Oracle: To specify this option, you must first set BULKLOAD=YES
or BULKUNLOAD=YES. The default value is NO.
Sybase IQ: To specify this option, you must first set BULKLOAD=YES.
The default value is
YES.
BL_DATAFILE= Data Set Option
BULKEXTRACT= LIBNAME Option
BULKEXTRACT= Data Set Option
BULKLOAD= Data Set Option
BULKUNLOAD= LIBNAME Option
BULKUNLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.