BL_ALLOW_WRITE_ACCESS= Data Set Option

Specifies that table data is still accessible to readers and writers while import is in progress.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Set Control
Default: NO
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Data source: DB2 under UNIX and PC Hosts
See: BL_ALLOW_READ_ACCESS= data set option, BULKLOAD= data set option

Table of Contents

Syntax

BL_ALLOW_WRITE_ACCESS=YES | NO

Syntax Description

YES

specifies that table data is still visible to readers and writers during data import.

NO

specifies that readers and writers cannot view table data during data import.

Details

For more information about using this option, see the SQLU_ALLOW_WRITE_ACCESS parameter in the IBM DB2 Universal Database Data Movement Utilities Guide and Reference.

Last updated: February 3, 2026