Physical Database DDL Statements › DBTABLE Statements

DBTABLE Statements

The DBTABLE statements perform the following tasks:

• Creates, alters, drops, displays, or punches a database name table definition in the dictionary
• Generates or deletes a database name table load module in the DDLCATLOD area of the dictionary

Authorization

• To create, alter, drop, or generate a database name table, you must have the following privileges:
  • DBADMIN on the dictionary in which the database name definition resides
  • CREATE (for creating), ALTER (for altering or generating), or DROP (for dropping) on the database name table
• To delete the database name table load module, you must have USE authority on the named load module.
• To display or punch the database name table, you must hold DISPLAY privilege on the database name table, or DBADMIN on the dictionary in which the database name table definition resides.