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

Examples

Creating a DMCL

The following statement creates DMCL IDMSDMCL:

create dmcl idmsdmcl;

Assigning Buffers

The following statement assigns buffers to files associated with the DMCL:

• File INDX_FILE in segment EMPSEG uses INDX_BUFF as its buffer
• All other files in segment EMPSEG use EMP_BUFF as their buffer
• All files in other segments in the DMCL use the default buffer

  alter dmcl idmsdmcl
       default buffer def_buff
       add segment projseg
       add segment empseg
           default buffer emp_buff
           file empseg.indx_file
           buffer indx_buff
       add segment payseg;