x

SQL 
SQL request;
TABLE
ON TABLE PCHOLD [FORMAT ALPHA]
END

where:

SQL request;

Is a valid SQL request, ending with a semicolon.

FORMAT ALPHA

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.

END

Is required on a separate line.

Top of page

Example: Using the ON TABLE PCHOLD Command

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.