Selection List Functions

AT

Displays the Object Attributes panel for this entity.

C

Copies this entity.

D

Deletes this entity.

I

Displays information about this entity.

LR

Lists the relationships for the indicated table. The indicated table is the table in the relationship that is not specified on the Choose a Relationship panel. (Relationship selection lists only.)

R

Renames this entity.

S

Selects this entity.

U

Unselects this entity. (Export Process selection lists only.)

• The AT line command is available on the selection lists for objects stored in the Optim™ Directory, such as:
  • Access Definitions
  • Archive Collections
  • Compare Definitions
  • Column Maps
  • Primary Keys (Optim Directory only)
  • Relationships (Optim Directory only)
  • Table Maps
  • Legacy Tables
  • Environment Definitions
  • Retrieval Definitions
• Use the AT line command to display the Object Attributes panel on which you can modify the description and security status of an object. (You control the selection list format via the Selection List Format option on the User Options panel.)
• Use the Copy line command to copy an existing object. However, a primary key can be copied only if the destination table exists and has the same key columns as the source table. A relationship can be copied only when the tables participating in the new relationship exist.
• The Delete line command is not available on the Select a Data Set panel or on object-specific selection lists in the Export Process.
• The Information line command is not available on the following panels:
  • Select Extract / Archive Data Set
  • Select Control Data Set
  • Select Legacy Table
  • Choose An Environment Definition
  • Choose A Retrieval Definition
• Use the Information line command on the Compare Summary Selection List to display the Extended Compare Table Information pop-up. This is the same information that is displayed with the INFO primary command while browsing the contents of a Compare File.
• The List Related line command is available on the Select Relationships panel.
• Use the Rename line command to rename an existing object. A primary key can be renamed only if the destination table exists and has the same key columns as the original table.
• The Select line command can be entered on all pop-up selection lists, as well as the following panels:
  • Select an Access Definition
  • Select a Compare Definition
  • Compare Summary Selection List
  • Select a Column Map
  • Select a Table Map
  • Select Extract / Archive Data Set
  • Select Control Data Set
  • Select Primary Keys
  • Select Relationships
  • Pending Process List
  • Indented Table Display
  • Select Legacy Table
  • Choose An Environment Definition
  • Choose A Retrieval Definition
• The Unselect line command is available when a selection list of specific objects is displayed for the Export Process. (Use the UNSELECT ALL primary command to unselect all objects.)

Archive Action List Functions

The following line commands are available on the Select an Action To Be Defined panel.

CLR

Clears a previously defined action.

INF

Lists any actions that share an SQL statement with the selected action.

S

Selects the action to be used and displays the Enter an SQL Statement panel to specify the SQL statement to be executed when processing has reached the point of the specified action.