Physical Database DDL Statements › DBTABLE Statements › Entity Currency › Examples

Examples

Defining a Database Name Table

The following statement creates the ALLDBS database name table. It illustrates the use of DBTABLE mappings to select a database name for processing. All run units binding with a subschema name beginning with CUST will access CUSTDB; those with names beginning with EMP will access the EMPDB; all others will access DEFDB.

create dbtable alldbs
   subschema emp????? maps to emp????? dbname empdb
   subschema cust???? maps to cust???? dbname custdb
   subschema ???????? maps to ???????? dbname defdb;

Generating a Database Name Table

The following example generates a load module for database name table ALLDBS:

generate dbtable alldbs;

Identifying the Default Dictionary

This example identifies TESTDICT as the default dictionary. The DBTABLE mapping maps all IDMSNTWK subschemas to dictionary TESTDICT. The dictionary contains segments for the base definition areas, catalog areas and the system message area:

create dbtable alldbs
  add subschema idmsnwk? maps to idmsnwk? dbname testdict;
 .
 .
 .
create dbname alldbs.testdict
  add segment testdict
  add segment catseg
  add segment sysmsg;