Pathmaker Reference Manual

Table Access Paths Screen
Pathmaker Screens
067869 Tandem Computers Incorporated 1–199
Field Descriptions The following paragraphs describe the fields on the Table Access Paths screen.
Table Name
Displays the name of the SQL table selected on the SQL Table Registration screen
when you navigated to this screen. You cannot enter data into this field.
Access Path Name
Enter the name of a new access path to be added.
To establish a starting point of a list, enter any existing access path name, the leading
characters of a name, or a blank and press F4.
Default
Enter Y or N:
Y Uses the Pathmaker computation of the Unique attribute for the Path. This is the
default value.
N Treats the access path according to the current value of the Unique attribute,
regardless of the existence of unique indices.
Unique
Enter Y or N:
Y Treats this access path as unique. The value is unique if the columns of the
access path include all the columns of any existing unique index on the table.
N Does not treat the access path as unique.
Whenever you change the current value of the Unique flag, either from Y to N or from
N to Y, the value of the Default flag, in the previous field, is forced to N.
Efficient
Displays a Y if the access path is efficient. The Pathmaker product determines that an
access path is efficient if SQL can use an underlying index to support the ordering of
rows in the execution of FETCH operations using this path. For more information, see
the Pathmaker Programming Guide.
Description
Enter up to 40 characters of text to describe the access path. This is optional.
Column Names
Displays an ordered list of columns of the current table.
Enter other names to change the composition of an access path or to add an access
path. Each name must be the name of a column in the current table. You cannot
repeat a column name in the list. The column order affects the sequence in which
rows are accessed by a generated FETCH operation.