Data Set Options for Relational Databases |
Specifies
that the original table data is still visible to readers
during bulk load.
Default value: |
NO
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS Support: |
DB2 under UNIX and PC Hosts
|
BL_ALLOW_READ_ACCESS=YES | NO
|
- YES
-
specifies that the original (unchanged) data in the table
is still visible to readers while bulk load is in progress.
- NO
-
specifies that readers cannot view the original data in
the table while bulk load is in progress.
To specify this option, you must first set BULKLOAD=YES.
For more information
about using this option, see the SQLU_ALLOW_READ_ACCESS
parameter in the IBM DB2 Universal Database Data Movement Utilities
Guide and
Reference.
BL_ALLOW_WRITE_ACCESS= Data Set Option
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.