Creating a PCHOLD File

The PCHOLD command enables you to extract data from a Reporting server and return the output to a FOCUS client. See the Overview and Operating Environments manual for information about using FOCUS as a client to a Reporting server.

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

Syntax: How to Create a PCHOLD File

The syntax for PCHOLD in a report request is

ON TABLE {PCHOLD|HOLD AT CLIENT} [AS filename] [FORMAT fmt]

where:

PCHOLD|HOLD AT CLIENT

Downloads HOLD files to a browser or other client application. 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. ALPHA is the default format.

To display as or in a webpage, choose:
```
HTML, HTMTABLE, DHTML
```
To display as a printed document, choose:
```
PDF, PS
```
To use in a text document, choose:
```
ALPHA, WP
```
To use in a spreadsheet application, choose:
```
DIF, EXCEL, 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
```

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