DBMASTER= Data Set Option
Designates which table is the larger table when
you are processing a join that involves tables from two different
types of databases.
| Valid in: |
DATA and PROC steps |
| Supports: |
All |
Syntax
Syntax Description
- YES
-
designates which of
two tables references in a join operation is the larger table.
Example: Join Two Tables
In the following example,
a table from an Oracle database and a table from a DB2 database are
joined. DBMASTER= is set to YES to indicate that the Oracle table
is the larger table. The DB2 table is the smaller table.
libname mydblib fedsvr server="d1234.us.company.com"
port=2171 user=user1 pwd=pass1
dsn=oradsn dsnuser=orauser dsnpwd=orapwd;
libname mydblib2 fedsvr server="d1234.us.company.com"
port=2171 user=user1 pwd=pass1
dsn=db2dsn dsnuser=db2user dsnpwd=db2pwd;
proc sql;
select * from mydblib.bigtab(dbmaster=yes), mydblib2.smalltab
bigtab.x=smalltab.x;