Pathmaker Reference Manual

PM31—Pathmaker SQL Table Access Paths
Pathmaker Report Descriptions
D–12 067869 Tandem Computers Incorporated
PM31—Pathmaker
SQL Table Access
Paths
ThePathmaker SQL Table Access Paths report lists the SQL tables registered in a catalog
and their access paths. For each access path, the report lists the following fields:
Table Object Name The name of the SQL table which defines the access path.
Access Path Name Name of an access path defined on the Table.
Unique Indicates whether the access path is regarded as a
unique path on the Table or not.
Indexed Indicates whether the access path can be scanned
using indexes on the SQL table or not.
Comments Comments associated with the access path.
PM32—Services
Referencing Data
Objects
The Services Referencing Data Objects report lists each service and the DDL definitions
and records, and SQL tables that it references as IPC parameters. For each reference,
the report lists the following fields:
Service Name The name of the service that references the object.
Service Type The type of the service.
CUSTOM user-written service included in a generated
server.
REG registered service included in a registered server.
IPC Type Indicates how the service uses the object:
RQ request IPC element
RP reply IPC element
Reference Name Name by which the object is known in the service.
Referenced Object Name of an object referenced by the service.
Object Type Type of the referenced object: Definition, Record, SQL Table.
PM33—Data Objects
Referenced by
Services
The Data Objects Referenced by Services report lists DDL definitions and records, and
NonStop SQL tables referenced by services. For each reference, the report lists the
following fields:
Referenced Object The name of the referenced definition, record, or table.
Object Type Type of the object:
ID DDL Definition
RD DDL Record
TB SQL Table
Service Name Name of a service that references the data object.
Service Type The type of the referencing service.