Displaying the keys assigned to a table

Overview

Line command K in the "Database Table Display" panel displays a key's short and long name, the length of the key, and the table the key is assigned to.

Procedure

1. Select option D.2 from the "Service Manager Selection Menu" to display the "Dictionary Selection Menu".
2. Select option 1 to call the "Display Database Tables" panel, which provides information on all the tables defined in the definition file.
3. Enter line command K in front of one of the tables displayed. The "Display Keys for Table xxxx" is called, showing a list of all the keys assigned to a table:

   PEB5DI22 ------------------------------------------------------ Row 1 of 1
   Command ===> ________________________________________________ Scroll ===> PAGE
   
   Display Keys for Table VC ( LEFT/RIGHT )
   
   S - Display key definition
   
   Sel Key Long Name Length Table Type
   VCKEY VCKEY 00023 VC UN
   ******************************** BOTTOM OF DATA ********************************
   
   
   
   
   
   
   
   
   
   
   
   
   
   

Columns

Column	Description
Type	Un indicates that the key is unique. Ge indicates that the key is used in a table more than once (generic).

Line commands

S	display all fields assigned to a key