Row-Level Security Screens › System Table Maintenance Screen—SYST

System Table Maintenance Screen—SYST

Description

The System Table Maintenance screen allows the DBA (or anyone with DBA authority) to access the following tables directly:

• $UNSTRUCTURED-IDB-OBJECT$
• $SECURITY-RUNTIME-TABLE$
• $OBJECT-SECURITY-NAME-TABLE$
• $SRT-OST-CROSS-REFERENCE$

Access

You can access the System Table Maintenance screen in one of the following ways:

• Select the System Table Maintenance function from the Administrator Control screen; you can select the function by pressing [PF8].
• Enter SYST in the screen name field of any field.

You can leave the System Table Maintenance screen in one of the following ways:

• Select an activity from the menu and press [Enter]; the appropriate screen for performing the activity you select will be displayed.
• Press [Clear] to return to the prior screen.
• Enter the screen name of another screen in the screen name field.

Sample Screen

                                                CA
  SYST   CA - Automatic System Facility           *System Table Maintenance*
  DC560727 SELECT A SYSTEM TABLE

  Table Name:

         _ PF1 - Help                       _ PF4 - Display/Change Data
         _ PF2 - Define Table               _ PF5 - Select Data
         _ PF3 - Load Data                  _ PF6 - Query


                     _ $UNSTRUCTURED-IDB-OBJECT$

                     _ $SECURITY-RUNTIME-TABLE$

                     _ $OBJECT-SECURITY-NAME-TABLE$

                     _ $SRT-OST-CROSS-REFERENCE$

Fields

Table Name

Displays the name of the table as specified on the System Table Maintenance screen.

[PF1] - Help

Invokes the Help screen.

[PF2] - Define Table

Invokes the Table Definition screen, which enables you to define a new table or to modify or delete an existing table.

[PF3] - Load Data

Invokes the Data Display screen for an existing table, which enables you to load data to be stored in the table.

[PF4] - Display/Change Data

Invokes the Data Display screen for an existing table, which enables you to display, change, delete, and load data.

[PF5] - Select Data

Invokes the Data Selection screen for a generated table, which enables you to select data for display by specifying selection criteria.

[PF6] - Query

Invokes OnLine Query, which enables you to display a generated table in row and column format. This function applies only if OnLine Query is installed at your site.