Data Set Options for Relational Databases BL_RECOVERABLE= Data Set Option 161
DBMS support: Oracle
Default value:
NO
Syntax
BL_PRESERVE_BLANKS=YES | NO
Syntax Description
YES
specifies that blank values are inserted as blank spaces.
CAUTION:
When this option is set to YES, any trailing blank spaces are also inserted. For
this reason, use this option with caution. It is recommended that you only set this
option to YES for CHAR columns. It is not recommended that you set this option
to YES for VARCHAR2 columns, because trailing blank spaces are significant in
VARCHAR2 columns.
NO
specifies that blank values are inserted as NULL values.
Details
Operating Environment Information: This option is not supported on OS/390.
To specify this option, you must first specify YES for the option “BULKLOAD= Data
Set Option” on page 165.
BL_RECOVERABLE= Data Set Option
Determines whether the LOAD process is recoverable
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 UNIX/PC
Default value:
NO
Syntax
BL_RECOVERABLE=YES | NO
Syntax Description
YES
