Pathmaker Programming Guide

Creating DB Requesters
Creating Requesters
067868 Tandem Computers Incorporated 5–45
If there is more than one file in the context for this DB requester (that is, this is a
multifile DB requester), and this file is a child, you also use the Record Instance Detail
screen to specify linkage information. Enter the qualified name of the parent’s link
field in the Parent field. Enter the elementary field name of the child’s link field in the
Child field. “Creating a Simple Application” in Section 10 has an example of
establishing a parent-child relationship.
Remember these important guidelines when you create a multifile DB requester:
You cannot mix DDL records and NonStop SQL table objects in the same DB
requester.
Enscribe allows you to create a file with a group data item as a primary key.
Likewise, NonStop SQL allows you to create a table with more than one column
declared as the primary key for the table.
A link field for a Pathmaker DB requester that accesses Enscribe files can be a
group data item; however, a link field for a Pathmaker DB requester that accesses
NonStop SQL tables must be a single column.
The link field of a child record must be a primary key field, an alternate key field,
or the leading (leftmost) portion of a primary or alternate key field. In other
words, the parent-child relationship in the Pathmaker product is a left-outer join.
The link field of the parent record must be the same length and type as the link
field of the child record.