Displaying field and key information

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 "Database Table Display" panel, which provides information on all the tables defined in the definition file.
3. Depending on what you want to see, do one of the following:
   • Enter line command F in front of one of the tables displayed. The "Display Fields for Table xxxx" is called, showing a list of all the fields assigned to a table.
   • 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 fields assigned to a table.
4. Select a field or a key with line command S:
   • From the "Display Fields for Table xxxx" to call the "Definition for Field xxxx" panel:

     PEB5DI24 ------------------------------------------------------ Row 1 of 1
     Command ===> ________________________________________________ Scroll ===> PAGE
     
     Definition for Field VCUSER
     
     Field Long Name C Internal External
     VCUSER VCUSER N C 0008 C 0008
     Comment : USER
     -------------------------------------------------------------------------------
     

   • From the "Display Keys for Table xxxx" to call the "Definition for Key xxxx" panel:

     PEB5DI23 ------------------------------------------------------ Row 1 of 4
     Command ===> ________________________________________________ Scroll ===> PAGE
     
     Definition 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
     

5. If you select a field definition with line command S in the "Definition for Key xxxx" panel, the "Definition for Field xxxx" panel is called for that particular field.

Token fields

Note that a token field (G) represents a logical name that summarizes a set of different fields. Therefore a token field cannot be selected with the line command S.

In panel "Display Fields for Table ...", the fields that are summarized in a token are listed below the token name. Calculate how many fields a token consists of. Add up the internal or external field length until the length of the token field is obtained. The following example shows a token field defined by an external length of 19; it consists of a date field (length 8) and a time field (length 11).

Internal	External
G 0008	G 0019
D 0004	C 0008
T 0004	C 0011