Pathmaker Reference Manual

SQL Table Value List Screen
Pathmaker Screens
1–194 067869 Tandem Computers Incorporated
SQL Table Value List
Screen
Use the SQL Table Value List screen to list the names and types of NonStop SQL tables
defined in a particular SQL catalog.
A NonStop SQL table name is a fully qualified file name that identifies a NonStop SQL
table.
You can select a NonStop SQL table on this screen and return it to the previous screen,
where you can work with it.
051
S Q L T A B L E V A L U E L I S T
==============================================================================
SQL Table Name: \HULK.$DATAII.FRAMETST.PICTS
SQL Catalog Name: \HULK.$DATAII.DAVIDCAT
==============================================================================
SQL Table Name Type
\HULK.$DATAII.FRAMETST.PICTS BASE TABLE
\HULK.$DATAII.FRAMETST.SQLNAMES BASE TABLE
\HULK.$DATAII.FRAMETST.SYSKEY BASE TABLE
\HULK.$DATAII.FRAMETST.TESTSQL BASE TABLE
\HULK.$DATAII.FRAMETST.VARYCHAR BASE TABLE
\HULK.$DATAII.GDMAINT.GDSONG BASE TABLE
\HULK.$DATAII.SQLTST.BADPRVW PROTECTION VIEW
\HULK.$DATAII.SQLTST.BADTYPE BASE TABLE
\HULK.$DATAII.SQLTST.BIGBOY BASE TABLE
\HULK.$DATAII.SQLTST.ENTRYSEQ BASE TABLE
\HULK.$DATAII.SQLTST.ENTRYVW PROTECTION VIEW
\HULK.$DATAII.SQLTST.GOODPRVW PROTECTION VIEW
\HULK.$DATAII.SQLTST.INNER BASE TABLE
\HULK.$DATAII.SQLTST.OUTER BASE TABLE
==============================================================================
F1-Select F4-List F9-Value List F16-Return
F5-List Next F10-Select & Return SF16-Exit
SQL tables listed
BLOCK
Displaying the Screen You reach the SQL Table Value List screen by placing the cursor in a data field and
pressing F9 from the SQL Table Registration screen.
Field Descriptions The following paragraphs describe the fields on the SQL Table Value List screen.
SQL Table Name
Displays the name of the SQL table from the SQL Table Registration screen.
To change the starting point of the list, enter any name, the leading characters of a
name, or a blank and press F4.
If this field is blank and you do not have a default catalog specified, you must enter a
NonStop SQL catalog name in the SQL Catalog Name field.