A HOLD file is the output of a report request stored in a file that you can use as input to another WebFOCUS procedure.
You can then create new report requests that extract data from the HOLD file, resulting in multi-step report.
HOLD files can be created to use in a report, chart, document, or visualization.
A HOLD file is valuable when you want to do the following:
HOLD files can be created for immediate use and saved temporarily or they can be stored for future and repeated use.
You can save a HOLD file for a report in the following formats:
Note: The Database Table output is only available when working against an SQL database.
Note: The Hyperstage output is only available when the reporting server has a Hyperstage adapter configuration.
Note: The Visual Discovery AE output option is only available with a Visual Discovery Analyst Edition license.
This section contains examples of how you would use a HOLD file.
To create a tabular report from a HOLD file, begin by creating a report.
The Temporary dialog box opens.
The custom database structure displays in the Resources panel. The canvas is returned to a default blank state, enabling the development of a new report using the HOLD file.
Note: The heading changes to FST Quantity Sold.
The final report displays.
The following procedure describes how to rearrange file components in a HOLD file.
Note: This procedure creates a binary HOLD file and a subquery to illustrate how to rearrange HOLD files. It also shows the result of this rearrangement.
In the Temporary dialog box, enter a name for the file. For example, File1_binary.
Select the original master file (wf_retail_lite.mas).
This creates a second report, which you can drag and resize as needed on the Document canvas.
In the File name field, enter File2_subquery and select the SQL Script (*.sql) format from the file types menu.
The Arrange Files dialog box opens.
Your report is refreshed to reflect the filtering you have applied.
FOCUS is the only format that supports an index field. The maximum number of fields to index is four. If the file format is FOCUS, then Index appears on the Query pane.
You can create a subquery using a HOLD file. A subquery is a nested query that is added to the Where clause of an SQL statement. A subquery is valuable because it is highly reusable.
This procedure describes how to create a subquery filter using a HOLD file created in the previous procedure.
The Filter dialog box opens.
The report is filtered by the subquery that you created.
Note: To view the SQL statements generated by the request, go to the Quick Access Toolbar, open the Run drop-down menu, and select SQL Trace.