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.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: 1
Requirement: To specify this option, you must first set BULKEXTRACT=YES, BULKLOAD=YES.
Data source: HP Neoview
See: BL_NUM_ROW_SEPS= LIBNAME option, BULKEXTRACT= LIBNAME option, BULKEXTRACT= data set option, BULKLOAD= data set option
Syntax
Details

Syntax

BL_NUM_ROW_SEPS=<integer>

Details

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.
Copyright © SAS Institute Inc. All rights reserved.