The LIBNAME Statement for Relational Databases

BL_NUM_ROW_SEPS= LIBNAME 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:	SAS/ACCESS LIBNAME statement
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.

For this option you must specify an integer that is greater than 0.

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.