Pathmaker Reference Manual

SQL Table Registration Screen
Pathmaker Screens
1–192 067869 Tandem Computers Incorporated
SQL Table Name
Displays all NonStop SQL table names that are associated with NonStop SQL table
object names and DEFINE names in this project. You can change this information.
If you are entering registration information, use the SQL Table Name column to enter
a valid file name that identifies the NonStop SQL table. The NonStop SQL table name
must exist but does not have to be unique, although Tandem recommends that you
use one DEFINE name and one table object name for each NonStop SQL table. The
simple NonStop SQL table name can be identical to the table object name and the
DEFINE name (without the equal sign).
To list by NonStop SQL table name, position the cursor in one of the fields in the SQL
Table Name column and press F4. The list begins with the NonStop SQL table name
where the cursor is positioned. You can also type over a NonStop SQL table name in
the SQL Table Name column and press F4 to change the starting point of the list.
If you are listing registration information by NonStop SQL table name, an asterisk (*)
appears immediately to the left of the heading for this column. The items in the SQL
Table Name column are listed alphanumerically. Pressing F5 causes the Pathmaker
product to continue listing by NonStop SQL table name.
Functions The following paragraphs summarize the functions available on the SQL Table
Registration screen, including those functions that are not displayed on the screen.
F2-Update
Updates NonStop SQL table registration information in the Pathmaker project catalog.
F4-List
Lists items that match or follow the item in the field where the cursor is positioned.
F5-List Next
Display the next set of items.
F6-Insert Line
Inserts a blank line above the line with the cursor. The items on the bottom scroll off
the display, but remain in the list.
F7-Access Paths
Accesses the Table Access Paths screen, which allows you to manage named access
paths for the current SQL table.
F9-Value List
Accesses the SQL Table Value List Screen, which lists all the NonStop SQL tables for a
particular catalog.