Pathmaker Programming Guide

Coding Custom Services
Creating Services and Servers
4–50 067868 Tandem Computers Incorporated
Sending Rows and Columns to Services
Depending on the needs of the service, you might want to:
Send an entire row of a table to a service
Send a single column to a service
Send selected columns from one or more tables to a service
Sending an entire row to a service is the simplest approach. To send an entire row,
you specify the table name on the IPC Definition screen of the service and the SEND
Parameter Definition screen of the requester. See “Creating a NonStop SQL
Pathmaker Application” in Section 10 for an example of sending an entire row to a
service.
If you want to send a single column to a service, you can match a single column name
to an Enscribe DDL definition in the service. Suppose you have the table EMPLOYEE.
EMPLOYEE has the following SQL DDL definition:
CREATE TABLE EMPLOYEE
(
EMPNUM PIC 9 COMP,
EMPFNAME PIC X(20),
EMPINITIAL PIC X,
EMPLNAME PIC X(20),
PRIMARY KEY (EMPNUM)
)
ORGANIZATION KEY SEQUENCED;
Suppose you only want to send the EMPNUM column to the service. Create a DDL
definition that matches the length and type of EMPNUM and add it to your
Pathmaker catalog:
DEF EMPNUMBER PIC 9 COMP.
On the Pathmaker service menus:
Add the table EMPLOYEE to the Logical File Entries screen.
Add EMPNUMBER to the IPC Definition screen.
On the Pathmaker requester menus:
Add the table EMPLOYEE to the Requester Context screen.
Match the column name (EMPLOYEE.EMPNUM) to the DDL definition on the
SEND Parameter Definition screen. Note that you must qualify the column name
with the table name. The SEND Parameter Definition screen should look
something like this:
Requester Reference Field
SEND: employee.empnum
TO: empnumber