Action codes
Many of the panels in the products contain a scrollable list of items. When the panel contains an Act column in the list, you can enter an action code (or line command) in the field adjacent to the object on which you want to take an action.
Not all action codes are valid for every object on a panel. The Use column in the following table lists the objects on which an action code can be used.
Action code | Definition | Description | Use |
|---|---|---|---|
A | After | Copies or moves a key to the column after a particular column in a list of columns | TS, TB, FK, IX, UC, CK, TR, VW |
A | Analyze | Invokes the Analysis Interface panels for a work ID | Work ID |
AL | Aliases | Displays the aliases of a dependent object | SG, DB, TS, TB, GT, VW |
AX | Auxiliary object (LOB) | Displays the auxiliary objects for large object (LOB) columns that are associated with a base table (TBB) In the Table Columns List panel, this command can be used if the data type of the column is defined as a large object (LOB) (such as a binary large object, or BLOB; character large object, or CLOB; or double-byte character large object, or DBCLOB) or as a distinct or user-defined type (UDT) that is based on a LOB data type. | TBB, TBB column |
B | Before | Copies or moves a key to the column before a particular column in a list of columns | TS, TB, FK, IX, UC, CK, TR, VW |
B | Browse | Browses an object | Work ID, baseline, baseline profile, migrate profile, task ID, application, script |
C | Copy (Change Manager object) | Copies a migrate or baseline profile that is displayed in the object Profile Selection List panel You must change the profile name after copying the object. For a CM/PILOT task ID or script, this code creates a new task ID, script, or step in a script by using the current object as a template. | Baseline profile, migrate profile, task ID, script |
C | Copy (Db2 object) | Copies a key or column from a list of columns | TS, TB, FK, IX, UC, CK, TR, VW |
C | Create | Creates an object of the same type | SG, DB, TS, TB, GT, CK, FK, IX, VW, AL, SY, UC, SQ |
CAL | Create alias | Creates an alias | TB, GT, VW |
CAX | Create auxiliary object | Displays the create auxiliary object template panel, from which you can create auxiliary objects In the Table Columns List panel, this command can be used if the data type of the column is defined as a large object (LOB) (such as a binary large object, or BLOB; character large object, or CLOB; or double-byte character large object, or DBCLOB) or as a distinct or user-defined type (UDT) that is based on a LOB data type. This command cannot be used if you are liking or creating a base table (TBB). It can, however, be used when you edit the TBB after it has been stored in the CD tables. | TBB column |
CC | Block copy | Copies a block of keys or columns from a list of columns | TS, TB, FK, IX, UC, CK, TR, VW |
CCK | Create check constraint | Creates a check constraint | TB |
CDB | Create database | Creates a database | SG |
CFK | Create foreign key | Creates a foreign key | TB |
CGT | Create global temporary table | Creates a global temporary table | TB |
CIX | Create index | Creates an index or an auxiliary index for a large object (LOB) column on an existing base table (TBB) When creating auxiliary indexes, this command can be used in the Table Columns List panel if the data type of the column is defined as a large object (LOB) (such as a binary large object, or BLOB; character large object, or CLOB; or double-byte character large object, or DBCLOB) or as a distinct or user-defined type (UDT) that is based on a LOB data type. This command cannot be used if you are liking or creating a TBB. It can, however, be used when you edit the TBB after it has been stored in the CD tables. | TB, TBB column, aux TB |
CK | Check constraint | Displays the check constraint for a table | CK |
CM | Comment | Displays a comment panel for an object or an auxiliary object | TB, TBB, TBB column, TBQ, GT, IX, VW, TR, AL, VW, SP, SQ |
CMK | Create column mask | Creates a column mask for a table | TB |
CO | Column | Displays the columns in a table or a view, the index key columns and table columns in an index, or the constraint key columns and parent table columns in a primary or unique key constraint | TB, TBB, TBQ, GT, UCU, UCP, VW, IX |
CRP | Create row permission | Creates row permission for a table | TB |
CSY | Create synonym | Creates a synonym | TB, GT, VW |
CT | Constraint text | Displays the text associated with a check constraint | CK |
CTB | Create table | Creates a table or an auxiliary table for a large object (LOB) column When creating auxiliary tables, this command can be used in the Table Columns List panel if the data type of the column is defined as a large object (LOB) (such as a binary large object, or BLOB; character large object, or CLOB; or double-byte character large object, or DBCLOB) or as a distinct or user-defined type (UDT) that is based on a LOB data type. This command cannot be used if you are liking or creating a base table (TBB). It can, however, be used when you edit the TBB after it has been stored in the CD tables. | TS, GT, TBB column, aux TB |
CTC | Create clone table | Creates a clone table of an existing table | TB, TBB, TBBT, TBT |
CTR | Create trigger | Creates a trigger Typing CTR:
| TB, VW |
CTS | Create table space | Creates a table space or an auxiliary table space for a large object (LOB) column When creating auxiliary table spaces, this command can be used in the Table Columns List panel if the data type of the column is defined as a large object (LOB) (such as a binary large object, or BLOB; character large object, or CLOB; or double-byte character large object, or DBCLOB) or as a distinct or user-defined type (UDT) that is based on a LOB data type. This command cannot be used if you are liking or creating a base table (TBB). It can, however, be used when you edit the TBB after it has been stored in the CD tables. | DB, TBB column |
CUC | Create unique constraint | Creates a unique or primary constraint | TB, IX |
CVW | Create view | Creates a view | TB, GT, VW |
D | Delete | Deletes an object or a step in a script Use a number in conjunction with this action code to apply the action multiple times. | Work ID, baseline, baseline profile, migrate profile, task ID, application, script |
D | Drop | On a list panel, marks an object or an auxiliary object for dropping You cannot drop an altered object. To drop an altered object, undo the alter and then drop. Altering data structures (by using an alter-type work ID) causes the worklist to drop the object. Migrating data structures (by using a migrate-type work ID) does not drop the object but does exclude it from the migration. In the Mixed List panel, an orphaned auxiliary index cannot be dropped; instead, the requested changes for the index are removed. In the Auxiliary Tablespace List panel, an auxiliary table space cannot be dropped if it contains an auxiliary table or if the base table (TBB) is not dropped. An auxiliary table cannot be dropped if it contains data. An auxiliary index cannot be dropped unless it is empty or the TBB is dropped. | SG, DB, TS, TSA, TS partition, TB, TBB, TBB column, TB column, GT, CK, FK, IX, IX partition, IXA, IXUC, IXP, UCP, IXU, IXG, VW, TR, AL, SY, SP, SQ |
DB | Database | Displays the databases of a dependent object | SG |
DD | Block delete | Deletes a block of keys or columns from a list of columns | TS, TB, FK, IX, UC, CK, TR, VW |
DV | Default value | The Table Columns List panel or the Table Column Detail panel displays a default value panel from which you can specify a new default value for a column | TB column |
E | Edit (Db2 object) | Displays the detail panel for the selected object or auxiliary object on which you can specify change requests If you use the CAX command to create an auxiliary object, using the E action code in an auxiliary object list panel displays a create auxiliary object panel. | SG, DB, TS, TS partition, TB, TBB, TBQ, GT, CK, FK, IX, IX partition, VW, TR, AL, SY, SP, SQ |
E | Edit (Change Manager object) | Enables you to edit an object or a step in a script | Work ID, baseline profile, migrate profile, task ID, application, script |
E | Edit comment | Enables you to edit the comments for a baseline | Baseline |
FK | Foreign keys | Displays the foreign keys of the specified table | SG, DB, TS, TB |
FP | Fieldproc parameters | The Table Columns List panel displays the Table Column Fieldproc Parms panel, from which you can specify a field procedure exit routine and a parameter list for a column | TB column |
G | Generate CDL | Displays the Compare CDL Options panel, where CDL can be generated | Work ID |
GT | Global temporary table | Displays the global temporary tables | SG, DB, TS |
I | Insert | Adds a blank line to a list or inserts a step in a script Use a number in conjunction with this action code to apply the action multiple times. | Work ID, baseline profile, migrate profile, script |
ID | Identity column | The Table Columns List panel displays the Identity Column Detail panel, from which you can specify values for an identity column | TB column |
IX | Indexes | Displays the indexes of the specified object | SG, DB, TS, TB |
KY | Keys | Displays the keys of an index, the partition keys of a table that uses table-controlled partitioning, or the constraint keys of a unique or primary constraint | TBT, IX, UCP, UCU |
L | Like | Creates a new data structure definition, an object, or an auxiliary object by using the current definition as a template | SG, DB, TS, TS partition, TB, TBB, TB column, GT, CK, FK, IX, IX partition, VW, TR, AL, SY, SP, SQ |
L | List | Lists baselines created from a baseline profile or task IDs created from an application or a script | Baseline profile, application, script |
LIX | List indexes | Displays a list of the auxiliary indexes that are associated with a large object (LOB) column in a base table (TBB) In the Table Columns List panel, this command can be used if the data type of the column is defined as a large object (LOB) (such as a binary large object, or BLOB; character large object, or CLOB; or double-byte character large object, or DBCLOB) or as a distinct or user-defined type (UDT) that is based on a LOB data type. You cannot use this command if you are liking or creating a TBB. You can, however, use it when you edit the TBB after it has been stored in the CD tables. | TBB column |
LK | Limit key | In an index, table, or table space partition list, displays the limit key for a selected partition In a mixed list, if the table uses table-controlled partitioning, you can type LK adjacent to the associated table space or table to display all of the limit keys for all of the partitions. You cannot type LK adjacent to an index in which the table uses table-controlled partitioning. In a mixed list, if the table uses index-controlled partitioning, you can type LK adjacent to the index to display all of the limit keys for all of the partitions. You cannot type LK adjacent to the associated table space or table. | TS, TST, TB, TBT, IX |
LTB | List tables | Displays a list of the auxiliary tables that are associated with a large object (LOB) column in a base table (TBB) In the Table Columns List panel, this command can be used if the data type of the column is defined as a large object (LOB) (such as a binary large object, or BLOB; character large object, or CLOB; or double-byte character large object, or DBCLOB) or as a distinct or user-defined type (UDT) that is based on a LOB data type. This command cannot be used if you are liking or creating a TBB. It can, however, be used when you edit the TBB after it has been stored in the CD tables. | TBB column |
LTS | List table spaces | Displays a list of the auxiliary table spaces that are associated with a large object (LOB) column in a base table (TBB) In the Table Columns List panel, this command can be used if the data type of the column is defined as a large object (LOB) (such as a binary large object, or BLOB; character large object, or CLOB; or double-byte character large object, or DBCLOB) or as a distinct or user-defined type (UDT) that is based on a LOB data type. This command cannot be used if you are liking or creating a TBB. It can, however, be used when you edit the TBB after it has been stored in the CD tables. | TBB column |
M | Maintain change rules | Displays change rules for a location | Migrate profile |
M | Migrate | Requests that the specified object be migrated This action code is valid for a migrate-type work ID only. In the Mixed List panel, you cannot use the M action code on orphaned auxiliary objects. | SG, DB, TS, TB, GT, CK, FK, IX, VW, TR, AL, SY, SPE, SPS, SPN, SPNA, SQ |
M | Move | Moves a key or column to the column before or after a particular column | TS, TB, FK, IX, UC, CK, TR, VW |
MM | Block move | Moves a block of keys or columns from a list of columns | TS, TB, FK, IX, UC, CK, TR, VW |
MO | Migrate options | Modifies the Migrate Options flag and marks the specified object for migration This action code is valid for a migrate-type work ID only. To migrate the auxiliary objects for a large object (LOB) column, you must migrate the base table. In the Mixed List panel, you cannot use the MO action code on orphaned auxiliary objects. | SG, DB, TS, TB, TBB, GT, CK, FK, IX, VW, TR, AL, SY, SPE, SPS, SPN, SPNA, SQ |
MT | Materialized query table (MQT) text | Displays the text associated with a materialized query table (MQT) | TBQT, TBQ |
O | Options | Displays the options for a step in a script | Script |
P | Protect | Indicates to protect a baseline from deletion | Baseline |
PA | Propagate attributes | Propagates the values for the number of rows, primary quantity, secondary quantity, and allocation unit attributes of a selected partition to all of the partitions in an index or a table space | TS, IX |
PE | Propagate estimates | Propagates the estimated space to the primary quantity for the specified partition in an index or a partitioned table space | TS, IX |
PK | Primary key | Displays a list of columns that can be used in a unique or primary constraint | TB |
PM | Procedure parameters | Displays a list of parameters for a stored procedure | SPE, SPN, SPNA |
PO | Procedure options | Displays options for external stored procedures and native SQL stored procedures | SPE, SPN, SPNA |
PT | Partitions | Displays information about the partitions of a table space or index In a mixed list, if a table uses table-controlled partitioning, you can type PT adjacent to a TST or TBT to display information for all of the table space partitions. You cannot type PT adjacent to a table that uses index-controlled partitioning. This code also displays information for a nonpartitioned table space or index. For large (larger than 2 GB), nonpartitioned, VCAT-defined table spaces and indexes that are supported by multiple data sets, a row is displayed for each data set. | TS, TST, TBT, IX |
QE | Quick edit | Marks tables for renaming Used in conjunction with the USE action code. | TB |
R | Delete | Deletes baselines using the DELETEAGE and RETAINMAX values in the baseline profile | Baseline profile |
R | Repeat | Creates an object from a template (synonym for Like action) Use a number in conjunction with this action code to apply the action multiple times. | SG, DB, TS, TS partition, TB, GT, CK, FK, IX, IX partition, VW, TR, AL, SY |
R | Report | Selects a baseline for a baseline report | Baseline |
RR | Block repeat | Repeats a block of keys or columns from a list of columns | TS, TB, FK, IX, UC, CK, TR, VW |
S | Select | Selects one or more items from a list | Work ID, baseline, baseline profile, migrate profile, script, task ID, application |
S | Specify | Invokes Specification for a work ID | Work ID |
S | Steps | Displays the steps in a script | Script |
SY | Synonym | Displays the synonyms of a table or view This command can be used from the BMC Environment panel for a plan. | SG, DB, TS, TB, GT, VW, PL |
TB | Tables | Displays the dependent tables of the specified object | SG, DB, TS |
TR | Trigger | Displays the trigger for a table | SG, DB, TS, TB |
TS | Table spaces | Displays the dependent table spaces of the specified object | SG, DB |
TX | Text | Displays the text associated with a check constraint, trigger, view, materialized query table (MQT), or XML index in the Mixed List panel | CK, IXV, IXVU, SP, TBQ, TBQT, TR, VW |
TX | Text | Displays the text associated with an index on an expression in the Index Keys List or Index Key Mixed List panels | IXS, IXSU, IXST |
U | Undo | Removes requested changes for the object or auxiliary object In the Mixed List panel, using the U action code on a base table (TBB) that has changes only to the auxiliary objects will not remove the @ change indicator. To remove the indicator, use the U action code on the auxiliary object in the Auxiliary Objects List panel. | SG, DB, TS, TSA, TB, TBB, GT, CK, FK, IX, IXA, VW, TR, AL, SY, SPE, SPS, SPN, SPNA, UC, SQ |
U | Unprotect | Removes the protected designation from a baseline, thus allowing it to be available for deletion | Baseline |
UC | Unique constraint zoom | Displays all of the unique or primary constraints for the specified object | DB, TS, TB, IX |
USE | Use | Specifies the new table space for tables renamed using QE (quick edit) | TS |
V | Execution status | Displays the execution status of a work ID | Work ID |
V | View sync table | Displays the execution status of a task ID | Task ID |
VL | Volume list | Displays a volume list from a Tablespace Parts List or Index Parts List panel | SG |
VT | View text | Displays the text associated with a view | VW |
VW | Views | Displays the dependent views of the specified object | SG, DB, TS, TB, GT, VW |
W | Edit worklist | Edits the worklist for the specified work ID | Work ID |
X | Create | Creates a baseline from a baseline profile or creates a task ID from an application or a script | Baseline profile, application, script |
X | Execute | Executes an ID | Work ID, task ID |
XM | Auxiliary object (XML) | Displays the auxiliary objects for XML columns that are associated with a base table (TBB) | TBB, TBB column |
Z | Zoom | Displays all of the dependencies for the specified object in the Mixed List panel You cannot use the Z action code with an object that has been marked to be dropped. | SG, DB, TS, TB, TB column, TBB column, GT, CK, FK, IX, VW, TR, AL, SY, TRA, IXCT2, TSR2 |
Related topic