A HOLD file is valuable when you want to do the following:
- Extract fields from a large data source for faster and more efficient retrieval in subsequent requests. This reduces processing time, enabling you to create reports and charts rapidly against a smaller, more specialized data set. This improves efficiency while giving you the flexibility that you need when working with smaller subsets of your data.
- Store virtual field values or summary values calculated in one request for further processing in another request. This allows you to reuse calculated values, decreasing the effort required to recreate certain scenarios.
HOLD files can be created for immediate use and saved temporarily or they can be stored for future and repeated use. This gives you the flexibility to use and store HOLD files, as needed, based on how you want to use the files that you create.
Creating HOLD Files
- Navigate to your saved report and right-click.
- From the right-click menu, select Edit With.., and then click InfoAssist.
- Click File from the Format group of the Home tab on the ribbon.
- From the Temporary hold dialog box, notice the options to rename the file, modify the file format, as well as options to select a desired location when saving.
- Click the file type dropdown to modify the file format to Focus(*.foc).
- Once a file name and file format is identified, click Save. The Temporary File dialog box will close.
Notice how this changes the format of your work area and the different options that are now available. The PRINT/SUM work area and the SORT work area are now gone and the Files section appears in their place. Also note the “Create Report” drop down box at the screen bottom center. Opening that will enable working with the held data file.
The output from the first query has been held in the filename provided and now that file appears as our source for report, file, or chart creation. The first query shows up in the QUERY block to the left side, listed under files. If you wish to navigate back to the first query that created the hold file highlight it and click Edit.
Expand the hold file to display the fields that you held by clicking on the plus signs to the left of the file name and then to the left of SEG01. SEG01 is the temporary name given to the file by WebFOCUS. Notice the appearance of the field called FOCLIST. That is an internal index created by WebFOCUS and used as a key field and also to differentiate like records in this case.
The output created from the hold file can be format as report output or sent to another hold file for further processing.
Related Articles