Pathmaker Reference Manual

Sample Enform Query Fragments

Project Catalog

4–14 067869 Tandem Computers Incorporated

Sample Enform Query

Fragments

1. The following Enform query fragment shows how you link objects to generate a

report for requesters calling other requesters:

OPEN odf, requester, action,

called-odf AS COPY OF odf,

called-req AS COPY OF requester;

LINK odf.object TO requester.requester-ed;

LINK requester.requester-id TO action.requester-id;

LINK action.action-object TO called-odf.identifier;

LINK called-odf.object TO called-req.requester-id;

2. This Enform query fragment shows how you link objects to generate a report to

list DDL RECORDs and SQL TABLEs that are referenced by custom services:

OPEN odf, svc, slf;

LINK odf.object TO svc.service-id;

LINK svc.service-id TO slf.identifier.service-id;

3. This Enform query fragment shows how you link objects to generate the date and

time of every requester generated in a catalog:

OPEN odf, requester;

DECLARE date-generated AS DATE *;

DECLARE time-generated AS TIME *;

LINK odf.object TO requester.requester-id;