Data Set Options for Relational Databases |
Determines how the SQL*Loader handles requests to insert blank
spaces into CHAR/VARCHAR2 columns with the NOT NULL constraint.
Default value: |
NO
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Oracle
|
BL_PRESERVE_BLANKS=YES | NO
|
-
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 set this option to YES only for CHAR columns. Do not set this option
to YES for VARCHAR2 columns because trailing blank spaces are significant
in VARCHAR2 columns. ![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
-
NO
-
specifies that blank values are inserted
as NULL values.
To specify this option, you must first
set BULKLOAD=YES.
Operating Environment Information: This option is not
supported on
z/OS. ![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.