Specifies an override character sequence that delimits rows or records in data during data transfer or retrieval during bulk loading.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | \x0A\x02\x0A (line feed, Control-B, line feed) |
| Data source: | SAP IQ |
| See: | BL_COLUMN_DELIMITER= data set option |
Table of Contents
specifies a sequence
of one to four characters that delimit rows in your data. Choose a
sequence that does not appear in your data. Specify this sequence
as printable characters, hexadecimal values, or both. Specify hexadecimal
values in the format '\xHH', where HH can represent any value from
00 to FF. For example, you might specify the three-character sequence BL_ROW_DELIMITER='AB\x09',
which represents the characters ‘AB’ followed by a tab
character.