How to: |
The PCHOLD command enables you to extract data from the WebFOCUS Reporting Server by way of the WebFOCUS client, and automatically display the data in HTML format in your browser.
In addition, if you have established a helper application, you can use the command ON TABLE PCHOLD to display the data in the helper application's viewer. For example, if a procedure contains the ON TABLE PCHOLD FORMAT EXCEL command, data is not returned to the browser in HTML format. Instead, data is returned and imported into an Excel spreadsheet, or other spreadsheet program you specify to your browser.
In contrast, when data access is handled directly by the Reporting Server (without intervention by the WebFOCUS Client), as is the case for Developer Studio used in client/server mode, then the data is extracted to a PCHOLD file and automatically delivered to your PC for local reporting.
Note: If your environment supports the SET parameter SAVEMATRIX, you can preserve the internal matrix of your last report in order to keep it available for subsequent HOLD, SAVE, and SAVB commands when the request is followed by Dialogue Manager commands. For details on SAVEMATRIX, see the Developing Reporting Applications manual.
The syntax for PCHOLD in a report request is
ON TABLE {PCHOLD|HOLD AT CLIENT} [AS filename] [FORMAT fmt]
where:
If you specify an ON TABLE PCHOLD command without a FORMAT, XML/HTML code is returned to the browser. In WebFOCUS Version 4.2.1a, the Master File and report output are returned to the browser. To avoid this, use ON TABLE HOLD FORMAT ALPHA.
HTML, HTMTABLE, DHTML
PDF, PS
ALPHA, DOC, WP
DIF, EXCEL, EXL2K [PIVOT], LOTUS
ALPHA, BINARY
For details about all available formats, see Choosing Output File Formats.
WebFOCUS |