Pathmaker Reference Manual

SQL Table Value List Screen
Pathmaker Screens
1–196 067869 Tandem Computers Incorporated
SHORTHAND VIEW
A view that can be derived from one or more tables or views by linking tables or
views, by selecting columns, by projecting rows, or by a combination of these. A
shorthand view can be read but not updated or secured.
PROTECTION VIEW
A view defined with the protection attribute. The view can be derived from a
single table by taking either a projection of the columns of the table, a selection of
the rows in the table, or both. A protection view provides a form of field level
security because the view can be secured, updated, and read.
Functions The following paragraphs summarize the functions available on the SQL Table Value
List screen, including those functions that are not displayed on the screen.
F1-Select
Selects a starting point for the SQL Table Value List. To select an item, move the
cursor to the name in the SQL Table Name column and press F1. The NonStop SQL
table name and the catalog name for that table are displayed at the top of the screen.
F4-List
Lists tables that match and follow the table in the SQL Table Name field. If the SQL
Table Name field is blank, the Pathmaker product begins the list with the first table
registered in the system, if you have a default catalog specified.
Type a name in the SQL Table Name field or use F1 to select a starting point for the
list.
F5-List Next
Lists a following set of tables.
F9-Value List
Lists detailed information about the structure of a particular NonStop SQL table or
view.
F10-Select & Return
Selects an item on the SQL Table Value List and returns to the previous screen where
the table name is shown. To select and return for an item, move the cursor next to the
name in the SQL Table Name column and press F10.
F14-Print Screen
Prints the SQL Table Value List screen.