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

Examples

Defining a Database Name

This example defines a production database (EMPDB) and a test database (TESTDB) as entries in database name table ALLDBS. EMPDB contains two segments: EMPSEG containing employee information and PROJSEG containing project information. Similarly, TESTDB contains two segments, TEMPSEG and TPROJSEG containing test employee and project data.

create dbname alldbs.empdb
  add segment empseg
  add segment projseg;

create dbname alldbs.testdb
  add segment tempseg
  add segment tprojseg;

Using Wildcards to Map Subschemas

In this example, the database name TESTDB is changed to map any subschema name beginning with PROD to a subschema name beginning with TEST. The last 4 characters of the subschema name remain unchanged.

alter dbname alldbs.testdb
  add subschema prod???? maps to test????;