Alternate View of the Logical View (VEW2)

Alternate View of the Logical View (VEW2) is an alternate view of View (VIEW) and is used for inquiry purposes only. This window is keyed by the alternate view table number. This allows the user to easily locate the table number of the alternate view's associated table. Information in this window is read when the Alternate Views out of Sync (SA7) report is generated to ensure that alternate views are synchronized with their tables.

Since this window is an alternate view of View (VIEW), whenever View (VIEW) is updated, the information in this window is also updated.

  •  
  •  

Alternate View Table Number

Key field. Enter the table number of the alternate view table.

Base Table Number

Key field. Enter the table number of the alternate view's associated base table.

View Type

Key field. This field is six characters. The first four characters are the view type and the last two are the view subtype. The value of this field is always 0001 00 .

Sequence

Key field. This number ensures key uniqueness. Enter one entry for each field of the application table used as part of the secondary key.

Offset

The starting location of the field, which is part of the secondary key, is displayed.

Length

The length of the field is displayed.

Function

The value of this field is always 00 .