Data Set Options for Relational Databases |
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
|
BL_DB2STORCLAS=storage-class
|
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.
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;
BL_DB2DATACLAS= Data Set Option
BL_DB2DEVT_PERM= Data Set Option
BL_DB2MGMTCLAS= Data Set Option
BL_DB2UNITCOUNT= Data Set Option
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.