DMCL Statement

DMCL statements perform the following tasks:
idms19
DMCL statements perform the following tasks:
  • Create, alters, or deletes the definition of a DMCL in the dictionary
  • Generate a DMCL load module and stores it in the DDLCATLOD area of the dictionary
  • Delete a DMCL load module from the DDLCATLOD area of the dictionary
  • Display or punches the definition of a DMCL in the dictionary
This topic contains the following information on DMCL statements:
 
 
2
 
 
Authorization
  • To create, alter, drop or generate a DMCL, you must have the following privileges:
    • DBADMIN on the dictionary in which the DMCL definition resides
    • CREATE (for creating), ALTER (for altering and generating), or DROP (for dropping) privilege on the named DMCL
    • To alter a DMCL you must have USE authorization on any dbtable including the DMCL
  • To display or punch a DMCL definition, you must have DISPLAY privilege on the named DMCL or DBADMIN authority on the dictionary in which the DMCL definition resides
  • To associate a database name table with a DMCL, you must have USE privilege for the named database name table
Syntax
CREATE/DROP DMCL
►►──┬─ CREATE ─┬─ DMCL dmcl-name ─────────────────────────────────────────────►◄
└─ DROP ───┘
ALTER DMCL
►►── ALTER DMCL dmcl-name ────────────────────────────────────────────────────►
►──┬────────────────────────────────────────────┬────────────────────────────►
└─ DEFAULT BUFFER ─┬─ default-buffer-name ─┬─┘
└─ NULL ◄───────────────┘
►──┬──────────────────────────────┬──────────────────────────────────────────►
└─ DBTABLE ─┬─ dbtable-name ─┬─┘
└─ NULL ◄────────┘
►──┬────────────────────────────────────────┬────────────────────────────────►
│ ┌────────────────────────────────────┐ │
└─▼-─┬─ segment-specification ───────┬─┴─┘
├─ file-override-specification ─┤
└─ area-override-specification ─┘
►──┬────────────────────────────────────────────────┬────────────────────────►
└─ DATA SHARING ─┬─ NO ──────────────────────────┤
│ ┌───────────────────────────┐ │
└─▼─ data-sharing-attributes ─┴─┘
►───┬────────────────────────────────────────────────────────────────────────►
└─ MEMORY CACHE ─┬──────────────────────────────┬────────────────────────►
└─ LOCATION ─┬─ ANYWHERE ◄───┬─┘
└─ 64 BIT ONLY ─┘
►────────────────────────────────────────────────────────┬───────────────────►◄
►────────────────────┬──────────────────────────────────┬┘
└─ STORAGE LIMIT ─┬─ OPSYS ◄──────┬┘
└─ nnn ─┬─ MB ─┬┘
├─ GB ─┤
├─ TB ─┤
├─ PB ─┤
└─ EB ─┘
GENERATE DMCL
►►── GENERATE DMCL dmcl-name ─────────────────────────────────────────────────►
►─┬────────────────────┬─────────────────────────────────────────────────────►◄
└─ FOR ─┬─ MVS ◄───┬─┘
├─ VSE ────┤
└─ VM ─────┘
DELETE DMCL LOAD MODULE
►►─┬─ DELete ─┬─ DMCL LOAD MODULE dmcl-load-module-name ─────────────────────►
└─ DROP ───┘
►─┬─────────────┬───────────────────────────────────────────────────────────►◄
└─ PERMANENT ─┘
DISPLAY/PUNCH DMCL
►►─┬─ DISplay ─┬─ DMCL dmcl-name ─────────────────────────────────────────────►
└─ PUNch ───┘
┌───────────────────────────────────────┐
►─▼─┬───────────────────────────────────┬─┴──────────────────────────────────►
│ ┌────────────────┐ │
├─ WITh ──────┬─▼─┬─ AREas ────┬─┴──┘
└─ WITHOut ───┘ ├─ BUFfers ──┤
├─ FILes ────┤
├─ JOUrnals ─┤
├─ SEGments ─┤
├─ DETails ──┤
├─ HIStory ──┤
├─ ALL ◄─────┤
└─ NONe ─────┘
►─┬──────────────────────────┬───────────────────────────────────────────────►
└─ VERb ─┬─ DISplay ───┬───┘
├─ PUNch ─────┤
├─ CREate ◄───┤
├─ ALTer ─────┤
└─ DROp ──────┘
►─┬───────────────────────┬──────────────────────────────────────────────────►◄
└─ AS ─┬─ COMments ◄──┬─┘
└─ SYNtax ─────┘
Expansion of 
data-sharing-attributes
 
►►─┬─ LOCK ENTRIES lock-entry-count ───────────┬──