Data Set Options for Relational Databases

BL_DB2STORCLAS= Data Set Option

Specifies a storage class for a new SMS-managed data set.

Default value:	none
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS Support:	DB2 under z/OS

Syntax
Details
Example
See Also

Syntax

BL_DB2STORCLAS=storage-class

Details

A storage class contains the attributes that identify a storage service level that SMS uses for storage of the data set. It replaces any storage attributes that you specify in BL_DB2DEVT_PERM=.

This option applies to the control file (BL_DB2IN), the input file (BL_DB2REC), and the output file (BL_DB2PRINT) for the bulk loader. Use this option to specify a management class for a new SMS-managed data set. If SMS is not installed or active, the operating environment ignores any storage class that BL_DB2MGMTCLAS= passes. Your site storage administrator defines the storage class names that you can specify when you use this option.

Example

This example generates SMS-managed control and data files. It does not create the table, and you need not run the utility to load it.

libname db2lib db2 ssid=db2a;

data db2lib.customers (bulkload=yes
      bl_db2ldext=genonly
      bl_db2in='testuser.sysin'
      bl_db2rec='testuser.sysrec'
      bl_db2tblxst=yes
       bl_db2ldct1='REPLACE'
      bl_db2dataclas='STD'
      bl_db2mgmtclas='STD'
      bl_db2storclas='STD');
set work.customers;
run;