SYDn transactions execute a static DB2 UDB query to one of the DB2 UDB sample tables. The parameter is the department number. Add the RPC using the sgw_addrpc procedure described in “Defining the test RPC”.
To execute the SYDn RPC, do one of the following:
Enter this command at the isql prompt (replace SYDn with SYD1 or SYD2):
exec SYDn D11
go
If the directory containing the samples is on the search path, enter this command at the server console prompt:
SYDn D11
Output should look like this:
LAST_NAME EMP_DEPT EMP_PHONE SALARY --------- -------- --------- ------------- ADAMSON D11 4510 25,280.00 BROWN D11 4501 27,740.00 PIANKA D11 3782 22,250.00 STERN D11 6423 32,250.00 WALKER D11 2986 20,450.00 LUTZ D11 0672 29,840.00 SCOUTTEN D11 1682 21,340.00 YOSHIMURA D11 2890 24,680.00 JONES D11 0942 18,270.00 (9 rows affected, return status = 0)
The rest of the sample transactions demonstrate the Open ServerConnect programming techniques.