Displaying keys

Overview

Option D.2.2 provides information on all the keys defined in the database. It also enables you to display a list of all the fields assigned to a particular key, and the fields assigned to a particular table.

Procedure

Select option D.2 from the "Service Manager Selection Menu" to display the "Dictionary Selection Menu".
Select option 2 to call the "Display Database keys" panel:
PEB5DI03 ------------------------------------------------------ Row 1 of 1
Command ===> ________________________________________________ Scroll ===> PAGE

Display Database Keys ( LEFT/RIGHT )

F - Display field definitions T - Display table definitions

Sel Key Long Name Length Table Type
VCKEY VCKEY 00023 VC UN
******************************** BOTTOM OF DATA ********************************

Columns

Column	Description
Table	Name of the table a key is assigned to

Line commands

F	Display all the fields assigned to a key (see below).
T	Display all the fields assigned to a table. Supplies the same information as line command F in the "Display Database Tables" panel.

Fields assigned to a key

Enter line command F in front of a key to display the fields defined for that key:

PEB5DI21 ------------------------------------------------------ Row 1 of 4
 Command ===> ________________________________________________ Scroll ===> PAGE

 Display Fields for Key VCKEY

 S - Display field definition

 Sel Field Long Name C Pos Internal External
 VCUSER VCUSER N 00000 C 0008 C 0008
 VCPROF VCPROF N 00008 C 0004 C 0004
 VCGROUP VCGROUP N 00012 C 0003 C 0003
 VCNAME VCNAME N 00015 C 0008 C 0008
******************************** BOTTOM OF DATA ********************************