BL_METHOD= Data Set Option

Specifies the bulk-loading method to use for DB2.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Set Control
Default: CLILOAD
Requirement: You must specify BULKLOAD=YES to specify this option.
Data source: DB2 under UNIX and PC Hosts
Note: The default value changed from no default to CLILOAD in SAS 9.4M9.
See: BULKLOAD= data set option

Table of Contents

Syntax

BL_METHOD=CLILOAD | IMPORT | LOAD

Required Arguments

CLILOAD

causes SAS/ACCESS to use the DB2 command-line interface to call the LOAD utility.

IMPORT

causes SAS/ACCESS to use the IMPORT utility.

Note: If you are using SAS on a PC or UNIX platform but your data resides on DB2 on a z/OS platform, then you can specify only IMPORT for this option.

LOAD

causes SAS/ACCESS to use the LOAD utility.

Last updated: February 3, 2026