Pathmaker Reference Manual

1 Pathmaker Screens
067869 Tandem Computers Incorporated 1–1
This section documents all the Pathmaker screens. Screens are ordered alphabetically.
Screen field and function key definitions are given.
Access Path Value List
Screen
Use the Access Path Value List screen to display the name and description of existing
access paths defined for the current table.
Access paths are optional attributes of SQL table objects that identify an ordered set of
columns of the table for SELECT and FETCH operations. Each table object can have
up to 40 named access paths.
You can select an access path in the list and return it to the previous screen, where you
can work with it.
001
A C C E S S P A T H V A L U E L I S T
==============================================================================
Table Name: PERSON
Access Path Name: PRIMARY-KEY_____________________
==============================================================================
Path Name Uniq Eff Description
PRIMARY-KEY Y Y Created by Pathmaker
INDEX-EN-EMPNBR N Y Default path for alternate 1.
EMP-NO Y N Emp number, soc. sec. number
==============================================================================
F1-Select F4-List F10-Select & Return F16-Return
F5-List Next SF16-Exit
Access Paths listed
BLOCK
Displaying the Screen You reach the Access Path Value List screen by placing the cursor on the Access Path
name and pressing F9 from any of the following screens:
Table Access Paths
SQL Operations
SQL Operation Attributes