How to: |
In order for a Dialogue Manager procedure to return an answer set to a client application, a certain set of commands must be issued directly after the SQL request in the syntax of the procedure.
SQL
SQL request;
TABLE
ON TABLE PCHOLD [FORMAT ALPHA]
END
where:
Is a valid SQL request, ending with a semicolon.
Optionally specifies that the hold file on the client is a text file. Use any valid format available on the client, but the underlying transfer is in alpha format. FORMAT ALPHA is the default value.
Is required on a separate line.
This example shows how the ON TABLE PCHOLD command requests information from a table in a catalog.
SQL SELECT NAME, CREATOR, COLCOUNT, RECLENGTH FROM SYSTABLE; TABLE ON TABLE PCHOLD FORMAT ALPHA END
The result of the request is an answer set sent to the client application by the server.
iWay Software |