Data Set Options for Relational Databases

BL_NUM_ROW_SEPS= Data Set Option

Specifies the number of newline characters to use as the row separator for the load or extract data stream.

Default value:	1
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	HP Neoview

Syntax
Details
See Also

Syntax

BL_NUM_ROW_SEPS=<integer>

Details

To specify this option, you must first set BULKLOAD=YES.

You must specify an integer that is greater than 0 for this option.

If your character data contains newline characters and you want to avoid parsing issues, you can specify a greater number for BL_NUM_ROW_SEPS=. This corresponds to the records separated by clause in the HP Neoview Transporter control file.