Command line commands
Every panel has a Command line. The Command line usually appears directly beneath the title bar, although its position depends on your ISPF profile.
You can issue Command line commands to:
- Navigate among panels without using the menus
- Display BMC environment information
- Modify the appearance of panels
- Modify the function of the components of ALTER and BMC AMI Change Manager for Db2
- Display any BMC Administrative or Utility product message
You can enter the commands listed in the following table in uppercase or lowercase letters. Use the HELP command (F1) from any panel to see what commands are available from that panel. Some panels list frequently used commands at the bottom of the panel.
Command | Description |
---|---|
AI | Displays the Archive Table Information panel |
ALTER | Displays the Create, Alter, or Drop Db2 Objects panel You can issue this command only from the Main Menu. |
ATTR | Displays the panel attributes panel, from which you can change screen attributes and attributes for viewing objects with names that are too long to be displayed |
ATTR RESET | Resets the screen colors to the default colors |
AX | Displays a list of the auxiliary objects that are associated with the large object (LOB) columns in a base table (TBB) You can issue this command only from the Table Detail Panel (for a base table) or the Table Column Detail panel (for a LOB column). |
BROWSE | Invokes the ISPF BROWSE function on a named diagnostic data set You cannot use the BROWSE command if you specify TERM or SYSOUT for diagnostics. You can issue this command only from a panel in which a data set is named. |
CAL CR AL | Creates an alias |
CANcel | Exits the current panel without saving changes |
CAX | Creates an auxiliary table space, table, and index for an existing base table from the Table Column Detail panel |
CCK CR CK | Creates a check constraint |
CDB CR DB | Creates a database |
CFK CR FK | Creates a foreign key |
CGT CR GT | Creates a global temporary table In the Mixed List panel, this command is available for an existing table or base table or from the Command line. |
CH | Displays a changed object list from an object Specification panel or Mixed List panel Orphaned auxiliary indexes are displayed in the Unattached Objects Section of the list. |
CIX CR IX | Creates an index or an auxiliary index for a large object (LOB) column in an existing base table |
CM | Displays a comment panel for a table, base table, auxiliary table, table column, view, view column, alias, index, or auxiliary index from the appropriate detail or auxiliary template panel |
CMK CR MK | Creates a column mask for a table |
CO | Displays a column list for the object from an object detail panel |
CReate | Creates Db2 objects from the Mixed List panel, Changed Objects List panel, detail panel, or create panel |
CRP CR RP | Creates a row permission for a table |
CSG CR SG | Creates a storage group |
CSP CR SP | Creates an external stored procedure or a native SQL stored procedure |
CSQ CR SQ | Creates a sequence |
CSY CR SY | Creates a synonym |
CTB CR TB | Creates a table or an auxiliary table for a large object (LOB) column in an existing auxiliary table space |
CTC | Creates a clone table of an existing table This command is not valid on materialized query tables (MQTs), global temporary tables, other clone tables, or system-period temporal tables. |
CTR CR TR | Creates a trigger |
CTS CR TS | Creates a table space or an auxiliary table space for a large object (LOB) column in an existing base table |
CUC CR UC | Creates a unique or primary constraint |
CVW CR VW | Creates a view |
DOPTS | Displays a list of the keywords and values in the installation options module in an ISPF edit session This list does not include the installation option keywords that have been replaced by keywords in the product options file (POF). You can assemble the installation options in the session to create an additional installation options module. |
DROPALL | Drops all objects in the list Objects are selected to be dropped if the Act column is blank or marked ‘$’ for space estimation only. In the Mixed List panel, this command also applies to orphaned auxiliary objects. If an auxiliary object has been LIKEd, this command removes the requested changes for the object. That is, the command performs the actions of an UNDOALL command. |
DV | Displays the Table Column Default Value panel from the Table Column Detail panel |
END | Exits the current panel, saves any changes, and displays the next panel in sequence |
ENVI ENVIRONMENT | Displays the BMC Environment panel that contains information such as product name, version, installation options module name, ship date, and plan names |
FInd | Locates character strings in a scrollable list The syntax of the command is as follows: FInd[ string,'string', or 'string'][ NEXT, FIRST, LAST, or PREV] In the preceding syntax line:
The parameters are described as follows:
If you issue the FIND command with no parameters, the previously found string is located if it exists. If no previously found string exists, the cursor is located at the first item in the list, as displayed on the panel. |
FP | Displays the Table Column Fieldproc Parms panel from a Table Column Detail Panel |
HELP | Displays help information |
HI | Displays the History Table Information panel |
ICP | Converts a table to index-controlled partitioning from the Table Detail panel |
ID | Displays the Identity Column Detail panel from the Table Column Detail panel |
JCLDEBUG OFF/ON | Turns foreground JCL Generation debugging off or on |
KY | Displays the Index Keys List panel from an Index Detail panel For a table that uses table-controlled partitioning, you can type KY to display the Partitioning Key Mixed List panel from the Table Detail panel. This command is not valid for an index that is defined on an XML column. |
LIX | Displays a list of the auxiliary indexes that are associated with a large object (LOB) column from a column detail panel |
LK | Displays the Limit Key Detail panel from an Index Partition Detail panel (for index-controlled partitioning) or the Tablespace Partition Detail panel For a table that uses table-controlled partitioning, you can type LK on the Table Detail panel or the Tablespace Detail panel to display the Tablespace Parts List panel. |
LTB | Displays a list of the auxiliary tables that are associated with a large object (LOB) column from a column detail panel |
LTS | Displays a list of the auxiliary table spaces that are associated with a large object (LOB) column from a column detail panel |
MAINT | Displays the Product Maintenance List panel that contains information about fixes (PTFs) that you have applied to the product and the product components You can issue this command only from the BMC Environment panel. |
MAX | Displays the maximum assigned value for an identity column in the Identity Column Detail panel, or for a sequence in the Create Sequence panel or Sequence Detail panel |
MIGALL | Selects all objects, except auxiliary objects, in the mixed list for migration To migrate the associated auxiliary objects for a table, you must select tables and auxiliary objects from the Migrate Options Overrides panel. You cannot migrate orphaned auxiliary objects. Objects are selected for migration if the Act column is blank or marked ‘$’ for space estimation only. |
MIGRATE | Displays the Migrate Db2 Objects Using Specification panel You can issue this command only from the Main Menu. |
MP | Displays the parameters for a materialized query table (MQT) from the MQT Detail or Create MQT panel |
MQT | Converts a table to a materialized query table (MQT) from the Table Detail panel, or creates an MQT from the Create Table panel On the View Detail panel, you can issue this command to create an MQT that is based on the definition of the view. |
MT | Displays text for a materialized query table (MQT) from the Create MQT, MQT Detail, Create MQT Parameters, or MQT Parameters panel |
PA | Displays the path for a trigger, view, or check constraint |
PEALL | Propagates the estimated space to the primary quantity (PRIQTY) for all of the partitions in an index in the Index Space Estimation panel or in a table space in the Tablespace Estimation (Partitioned) panel |
PCO | Displays the Parent Key Columns panel from the Create Foreign Key panel This command is valid only when the parent table’s primary key is not used. |
PK | Displays the Constraint Key Mixed List panel from the Table Detail panel or Table Columns List panel |
POP | Toggles pop-up message boxes on or off |
PREVIOUS | Exits the current panel and displays the previous panel |
PT | Displays an object partition or attribute list panel from a detail or template panel For a table that uses table-controlled partitioning, you can type PT on the Table Detail panel or the Tablespace Detail panel to display the Tablespace Parts List panel. |
SE | Displays space estimation information from a Tablespace Detail or Index Detail panel |
SORT | Displays the Sort Specifications panel, from which you can specify the columns on which to sort a list of work IDs You can specify the sequence of the columns and the order of the data in the columns. You can also sort on a single column by placing the cursor within the heading for that column and pressing Enter. To return to the original sort order, issue the SORT command. If you specify a sequence for the Stat Date column, you cannot specify a sequence for the Stat YYYY, Stat MM, or Stat DD column. |
TCP | Converts a table to table-controlled partitioning from the Table Detail panel |
TSO POFRESET TSO POFRESET POF(dataSetName(POFMember)) | Resets all of the ISPF variables in the ISPF profile with the variables in the initial POF TSO POFRESET POF(dataSetName(POFMember)) resets all of the ISPF variables in the ISPF profile with the variables in the specified initial or user POF name. The POFRESET CLIST enables these commands. The CLIST is located in the HLQ.DBCLIB library. |
TX | Displays the view text, trigger text, check constraint text, materialized query table (MQT) text, index on an expression, or index defined on an XML column from the Mixed List panel, a Detail panel, or a Create panel The product formats some of the text for all of the objects, except for indexes on expressions and indexes defined on XML columns. |
UNDOALL | Removes the requested changes for all of the objects on the list In the Mixed List panel, this command also applies to orphaned auxiliary objects. |
VIEWX | Displays the execution status of a work ID from the Execution JCL Processing Interface panel |
VL | Displays the Volume List and SMS Classes panel for VCAT-defined table spaces from the Auxiliary Tablespace Attribute Detail panel or the Auxiliary Index Attribute Detail panel |
W | Enables you to edit the worklist for a work ID from the WORKID Selection List panel The work ID must have a status of Analyzed, Exec Strt, or Exec Comp. In addition, the work ID must not be used with an outbound migrate profile that specifies multiple locations, because the profile can be used to generate multiple worklists. |
XP | Displays the parameters for an index that is defined on an XML column from the Index Detail or Create Index panel |
Related topic