BL_USE_PIPE= Data Set Option

Specifies a named pipe for data transfer.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: DBMS-specific
Restriction: Not available for Oracle on z/OS
Requirement: To specify this option, you must first set BULKEXTRACT= YES [HP Neoview], BULKLOAD=YES [HP Neoview, Netezza, Oracle, Sybase IQ], or BULKUNLOAD=YES [Netezza, Oracle].
Data source: HP Neoview, Netezza, Oracle, Sybase IQ
See: BL_DATAFILE= data set option, BULKEXTRACT= LIBNAME option, BULKEXTRACT= data set option, BULKLOAD= data set option, BULKUNLOAD= LIBNAME option, BULKUNLOAD= data set option

Syntax

BL_USE_PIPE=YES | NO

Syntax Description

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.

Details

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: The default is YES. This option determines how 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.
Netezza: The default is YES.
Oracle: The default is NO.
Sybase IQ: The default is YES.