178 DBLABEL= Data Set Option Chapter 10
libname invty db2;
data invty.stock;
set addinv;
modify invty.stock(dbkey=partno) key=dbkey;
INSTOCK=instock+nwstock;
RECDATE=today();
if _iorc_=0 then replace;
run;
Details
When processing a join that involves a large DBMS table and a relatively small SAS
data set, you might be able to use DBKEY= to improve performance.
When specifying DBKEY, it is
strongly recommended that an index exists for the key
column in the underlying DBMS table. Performance can be severely degraded without
an index.
CAUTION:
Improper use of this option can decrease performance. See “Using the DBINDEX=,
DBKEY=, and MULTI_DATASRC_OPT= Options” on page 38 for detailed
information about using this option.
DBLABEL= Data Set Option
Specifies whether to use SAS variable labels as DBMS column names during output processing
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle, Microsoft
SQL Server, SYBASE, Teradata
Default value: NO
Syntax
DBLABEL=YES | NO
Syntax Description
YES
specifies that SAS variable labels are used as DBMS column names during output
processing.
NO
specifies that SAS variable names are used as DBMS column names.
Details
This option is valid only for creating DBMS tables.
