Data Set Options for Relational Databases

BL_USE_PIPE= Data Set Option

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

Syntax
Syntax Description
Details
See Also

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: 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.