Displaying the fields assigned to a table

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 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:

   PEB5DI21 ------------------------------------------------------ Row 1 of 7
   Command ===> ________________________________________________ Scroll ===> PAGE
   
   Display Fields for Table VC
   
   S - Display field definitions
   
   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
   VCRES VCRESERVE N 00023 C 0001 C 0001
   VCLENGTH VCLENGTH N 00024 S 0002 C 0004
   VCDATA VCVARIABLES N 00026 V 0256 V 0256
   ******************************** BOTTOM OF DATA ********************************
   
   
   
   
   
   
   
   

Columns

Column	Description
Field	Short name of the field
Long name	Full name of the field
C	N indicates non-conversion fields. Y indicates that a field will be converted. During data conversion a text is assigned to a field's value. The assigned text will be used for external display. Only flag and byte fields have to be converted.
Pos	Position of a field in the table.
Internal	Field format or type and internal field length The following field types may appear in this column:
External	Field type and external field length Whereas field types with non-displayable characters such as the date field can be used for internal data representation, external display requires the use of character fields (C).

Line commands

S	Display field information.

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