Creating a PCHOLD File

How to:

The PCHOLD command enables you to extract data

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 manual.

Syntax: How to Create a PCHOLD File

The syntax for PCHOLD in a report request is

ON TABLE PCHOLD [AS filename] [FORMAT fmt] [DATASET name.ext]

where:

PCHOLD
HOLD AT CLIENT is a synonym for PCHOLD. The output is saved with a Master File. For details about the behavior of PCHOLD, see Creating a HOLD File.
AS filename
Specifies a name for the PCHOLD file. If you do not specify a file name, PCHOLD becomes the default. Since each subsequent PCHOLD command overwrites the previous PCHOLD file, it is advisable to code a distinct file name in each request to direct the extracted data to a separate file, thereby preventing it from being overwritten by the next PCHOLD command.
FORMAT fmt
Specifies the format of the PCHOLD file.
  • To display as or in a webpage, choose:
    HTML, HTMTABLE, DHTML, VISDIS
  • To display as a printed document, choose:
    PDF, PS
  • To use in a text document, choose:
    ALPHA, DOC, WP
  • To use in a spreadsheet application, choose:
    DIF, XLSX, EXL2K [PIVOT], LOTUS
  • To use for additional reporting, choose:
    ALPHA, DFIX, COM, COMT, TAB, TABT
  • To use in another application choose:
    XML
  • To generate active output, choose:
    AHTML, APDF, AFLEX

For details about all available formats, see Choosing Output File Formats.

DATASET name.ext

Is used with FORMAT ALPHA to specify a file name and extension for the report output. The result depends on the Redirection Settings in the WebFOCUS Administration Console for the specified extension. If the extension is defined in the WebFOCUS Administration Console, and the Save Report value is yes, the report output will be saved in your Downloads directory with the specified file name and extension.

WebFOCUS

Feedback