BL_ALLOW_READ_ACCESS= Data Set Option

Specifies that the original table data is still visible to readers during bulk load.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: NO
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: DB2 under UNIX and PC Hosts
See: BL_ALLOW_WRITE_ACCESS= data set option, BULKLOAD= data set option
Syntax
Details

Syntax

BL_ALLOW_READ_ACCESS=YES | NO

Syntax Description

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.

Details

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