BL_IMPORT_TABLE_LOCK= Data Set Option

Specifies whether to lock the table for data import into column store tables.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Set Control
Aliases: BL_IMPORT_TABLE_LOCK
BL_TABLE_LOCK
Default: NO
Restriction: If you do not specify this option, then no locking occurs.
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Data source: SAP HANA
See: BL_IMPORT_BATCH_SIZE=, BL_IMPORT_OPTIONS=, BL_IMPORT_TYPE_CHECK=, BULKLOAD= data set option

Table of Contents

Syntax

BL_IMPORT_TABLE_LOCK=YES | NO

Syntax Description

YES

specifies to add the TABLE LOCK option to the SAP HANA IMPORT statement.

NO

specifies that no locking occurs.

Last updated: February 3, 2026