Pathmaker Reference Manual

SQL Table Registration Screen
Pathmaker Screens
1–190 067869 Tandem Computers Incorporated
SQL Table
Registration Screen
Use the SQL Table Registration screen to enter or to list NonStop SQL table
registration information, so that the SQL tables can be used by requesters or in
interprocess messages to requesters and services.
You can list the registration information by any one of three names:
Table object name
DEFINE name
NonStop SQL table name
A table object name is a Pathmaker object name that identifies a NonStop SQL table on
subsequent Pathmaker screens.
A DEFINE name is a logical name that you use in your embedded NonStop SQL code
to refer to a table. Using DEFINE names allows you to easily substitute test data and
actual data without changing the embedded NonStop SQL code.
A NonStop SQL table name is a fully qualified file name that identifies a NonStop SQL
table.
050
S Q L T A B L E R E G I S T R A T I O N
==============================================================================
*Table Object Name Define Name SQL Table Name
PERSON______________________
=PERSON_______________ \SYS2.$SQL.SQLDB2.PERSON_________
VEHICLE_____________________
=VEHICLE______________ \SYS2.$SQL.SQLDB2.VEHICLE________
______________________________
______________________ _________________________________
______________________________
______________________ _________________________________
______________________________
______________________ _________________________________
______________________________
______________________ _________________________________
______________________________
______________________ _________________________________
______________________________
______________________ _________________________________
==============================================================================
F2-Update F4-List F6-Insert Line F7-Access Paths
SF2-Delete Item F5-List Next F9-Value List F16-Return
BLOCK
Displaying the Screen You reach the SQL Table Registration screen by entering a table name, the leading
characters of a table name, or blanks and pressing SF1 from the Pathmaker Main
Menu.