

Physical Database DDL Statements › DMCL Statements
DMCL Statements
The DMCL statements perform the following tasks:
- Creates, alters, or deletes the definition of a DMCL in the dictionary
- Generates a DMCL load module and stores it in the DDLCATLOD area of the dictionary
- Deletes a DMCL load module from the DDLCATLOD area of the dictionary
- Displays or punches the definition of a DMCL in the dictionary
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 delete the DMCL load module, you must have USE authority on the DMCL load module
- 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
Copyright © 2014 CA.
All rights reserved.
 
|
|