Keywords
The CM/PILOT component creates keywords for each of the DML objects.
The following table lists the keywords and the Db2 catalog table to which the keyword corresponds. When you modify a DML statement, you can use the keywords as they are shown, singular forms of the keywords, or the actual Db2 catalog names. The keywords and names are resolved to the CAT2 aliases that are used by BMC AMI Change Manager for Db2 to access the Db2 catalog. For information about catalog aliases, see Customizing BMC Products and Solutions for DB2.
Object | Keyword | Db2 catalog table |
|---|---|---|
Alias | ALIASES | SYSIBM.SYSTABLES 1 |
Check constraint | CHECKS | SYSIBM.SYSCHECKS |
Column(table and view) | COLUMNS | SYSIBM.SYSCOLUMNS |
Column mask | CONTROLS MASKS | SYSIBM.SYSCONTROLS |
Database | DATABASES | SYSIBM.SYSDATABASE |
Field | FIELDS | SYSIBM.SYSFIELDS |
Foreign key | FOREIGNKEYS RELKEY | SYSIBM.SYSFOREIGNKEYS SYSIBM.SYSRELS |
Index | INDEXES | SYSIBM.SYSINDEXES |
Index key | KEYCOLUMNS | SYSIBM.SYSKEYS |
Index partition | INDEXPARTS | SYSIBM.SYSINDEXPART |
Parm | PARMS | SYSIBM.SYSPARMS |
Relation | RELS | SYSIBM.SYSRELS |
Routine | ROUTINES | SYSIBM.SYSROUTINES |
Row permission | CONTROLS PERMISSIONS | SYSIBM.SYSCONTROLS |
Sequence | SEQUENCES | SYSIBM.SYSSEQUENCES |
Storage group | STOGROUPS | SYSIBM.SYSSTOGROUP |
Synonym | SYNONYMS | SYSIBM.SYSSYNONYMS |
Table (includes Global Temporary Table) | TABLES | SYSIBM.SYSTABLES 2 |
Table space | TABLESPACES | SYSIBM.SYSTABLESPACE |
Table space partition | TABLEPARTS | SYSIBM.SYSTABLEPART |
Trigger | TRIGGERS | SYSIBM.SYSTRIGGERS |
View | VIEWS | SYSIBM.SYSTABLES 3 |
Volume | VOLUMES | SYSIBM.SYSVOLUMES |
1
The TYPE column in the SYSIBM.SYSTABLES table contains the value V for views.2 The TYPE column in the SYSIBM.SYSTABLES table contains the value A for aliases.
3 The TYPE column in the SYSIBM.SYSTABLES table contains the value T for tables.
Related topic