Pathmaker Reference Manual

SQL Table Value List Screen
Pathmaker Screens
067869 Tandem Computers Incorporated 1–195
SQL Catalog Name
Displays the name of the NonStop SQL catalog associated with the table in the SQL
Table Name field.
If the SQL Table Registration screen contained a table name when you navigated to
this screen, this field displays the catalog for that table. If the SQL Table Registration
screen did not contain a table, this field displays the default NonStop SQL catalog
name.
You specify the default NonStop SQL catalog name by using the DEFINES feature of
the Tandem NonStop Kernel. The Pathmaker program gets the SQL catalog name
from the default DEFINE name when you use SQL with the Pathmaker product. If
there is no default DEFINE name, there is no table for the Pathmaker product to read
and this SQL Catalog Name field is blank. For more on the DEFINES feature, see the
Guardian User’s Guide.
To specify a default SQL catalog, fill in the SQL catalog name from the command
interpreter using the ALTER DEFINE command:
21> SET DEFMODE ON
22> ALTER DEFINE =_DEFAULTS, CATALOG catalog-subvolume-name
For convenience in specifying a default SQL catalog, you can add these commands to
your TACLCSTM file.
To search for another NonStop SQL catalog, change the catalog name in this field and
relist the tables.
SQL Table Name
Lists the tables in the current NonStop SQL catalog, starting with the table in the SQL
Table Name field. You cannot enter data into this column.
To change the starting point of the current list, move the cursor to a table name in this
column and press F1.
To select a table for updating or deleting, move the cursor to a table in this list and
press F10. The Pathmaker program returns you to the previous screen and displays
the table name and detailed information about the table you selected.
Type
Displays the table type of each entry. Table type can be:
BASE TABLE
A table that has physical existence; that is, a table stored in a file. In contrast, a
view is a table that has a logical definition but no physical existence. A view is
derived by projecting a subset of the columns or selecting a subset of the rows
from one or more tables or other views.