Specifies a storage class for a new SMS-managed data set.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | none |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | DB2 under z/OS |
| See: | BL_DB2DATACLAS= data set option, BL_DB2DEVT_PERM= data set option, BL_DB2IN= data set option, BL_DB2MGMTCLAS= data set option, BL_DB2PRINT= data set option, BL_DB2REC= data set option, BL_DB2UNITCOUNT= data set option, BULKLOAD= data set option |
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 specifies the storage class names that you can specify when you use this option.
This example generates SMS-managed control and data files. It does not create the table, and you do not need to run the utility to load it.
libname db2lib db2 ssid=db2a;
data db2lib.customers (bulkload=yes
bl_db2ldext=genonly
bl_db2in='myusr1.sysin'
bl_db2rec=myusr1.sysrec'
bl_db2tblxst=yes
bl_db2ldct1='REPLACE'
bl_db2dataclas='STD'
bl_db2mgmtclas='STD'
bl_db2storclas='STD');
set work.customers;
run;