ON TABLE HOLD

How to:

When a server receives the results of an SQL request (an answer set) from another server, the answer set will either:


Top of page

x
Syntax: How to Use the ON TABLE HOLD Command
SQL 
SQL request;
ON TABLE HOLD [AS filename] FORMAT format 
END

where:

filename

Is the name of the file that holds the answer set. If filename is omitted, the name of the held file on the server is HOLD, and subsequent creations of HOLD files overlay each other. The file name is a symbolic name known to the operating system for the server environment.

format

Is one of the format options valid for the server. Possible values are:

ALPHA, BINARY, COMMA, DBASE, DB2, DIF, DOC (WebFOCUS ONLY), EXCEL,EXL2K (WebFOCUS ONLY), 
EXL2K PIVOT (WebFOCUS ONLY), FOCUS, FUSION,HTML, HTMTABLE, INGRES, INTERNAL, LOTUS, PDF, 
POSTSCRIPT, REDBRICK,SQL, SQLDBC, SQLINF, SQLMAC, SQLMSS, SQLODBC, SQLORA, SQLSYB, SYLK,TABT, WK1, WP
END

Is required on a separate line.


iWay Software