Extract Files Under Windows

In this section:

Reference:

WebFOCUS creates all extract files in a temporary directory on the WebFOCUS Reporting Server, or in a user-defined location on the WebFOCUS Reporting Server.


Top of page

x
Reference: Locating Extract Files Under Windows

WebFOCUS creates all extract files in a temporary directory under the directory specified by the EDATEMP environment variable in EDASERVE.CFG.


Top of page

x
HOLD Files Under Windows

How to:

A HOLD extract file is a sequential data source that contains the results of a report request. It may have a corresponding HOLD Master File. The extension for an extract file is ftm unless you specify the FORMAT option. If a Master File is created, it has the same name as the extract file, with the extension .mas.

If you specify the FORMAT FOCUS option with HOLD, WebFOCUS creates an extract file and a Master File, each with the file name FOC$HOLD. These files are then used as input to the procedure that creates the final FOCUS file. The new FOCUS and Master Files are created in the user temporary directory.



x
Syntax: How to Create a HOLD File Under Windows
ON TABLE HOLD [AS filename]

where:

filename

Is a name for the HOLD file. If you do not specify a file name, HOLD is used as the default name. Since each subsequent HOLD command overwrites the previous HOLD file, it is useful practice to code a distinct file name in each request to direct the extracted data to a separate file, preventing it from being overwritten.

For the complete syntax with all options, see the Creating Reports With WebFOCUS Language manual.


Top of page

x
Creating and Saving HOLD Files in Developer Studio Under Windows

How to:

Reference:

The Developer Studio environment is a non-persistent environment that does not permit saving a HOLD file and a related Master File without issuing additional commands.

To save a HOLD file to a physical location on a disk, do one of the following:



x
Syntax: How to Control Where the HOLD File Is Created
APP HOLD application_name

where:

application_name

Is an application name.



Example: Issuing the APP HOLD Command to Create a HOLD File

This example creates an extract file named HOLDFILE.FTM and a corresponding Master File named HOLDFILE.MAS in an application named sales.

APP HOLD sales
TABLE FILE CENTORD
SUM LINEPRICE
BY PRODNAME
ON TABLE HOLD AS 'holdfile'
END

You can use the Other tool (accessed from the Procedure Viewer) to issue the SET and APP HOLD commands before you access the Report Painter.



x
Reference: Controlling Where an Output File Is Created

The APP HOLD command controls where an output file is created for any write process in the application if a FILEDEF command has not been issued. This includes:

CREATE SYNONYM

Is not affected by the FILEDEF command. Do not use the APP HOLD command with the CREATE SYNONYM command. The recommendation for CREATE SYNONYM is:

CREATE SYNONYM appname/synonymname
ON TABLE HOLD

Should be used with caution and the APP HOLD command should be turned off immediately following the process that creates the output file. To turn off the effects of the command, issue APP HOLD without an appname.

The APP HOLD command refreshes files that are common across all users of an application. Do not use it in an application for private files, as it points to an application area shared by multiple users. If the same hold name (HOLD or AS filename, for example) is used, conflicts between users could result.


Top of page

x
SAVB Files Under Windows

How to:

A SAVB file is an extract file containing the results of a report request in internal format. That is, all numeric fields are stored in binary, and all character fields are padded with spaces to a multiple of four bytes. The file cannot be printed.

When a SAVB file is created, WebFOCUS does not create a Master File.



x
Syntax: How to Create a SAVB File Under Windows
ON TABLE SAVB [AS filename]

where:

filename

Is the name of the file. The default is SAVB. The default extension is FTM.

For the complete syntax with all options, see the Creating Reports With WebFOCUS Language manual.


Top of page

x
SAVE Files Under Windows

How to:

A SAVE file is an extract file that saves the data of a report, but does not save headings or subtotals, or create a Master File. It is a simple sequential character data file that can be used by other programs, or merged into another data file using a data maintenance request. The default format is simple character, although you can specify formats compatible with many other software products. WebFOCUS saves all columns in the report in printable, character format with no spaces between columns.

A SAVE file contains the external character format equivalent to SAVB. The command syntax and allocations are the same as SAVB. However, the numbers are printable Extended Binary Coded Decimal Interchange Code (EBCDIC) characters and no padding takes place.



x
Syntax: How to Create a SAVE File Under Windows
ON TABLE SAVE [AS filename]

where:

filename

Is the name of the file. The default is SAVE. The default extension is FTM.


Top of page

x
HOLDMAST Files Under Windows

How to:

A HOLDMAST file is a temporary Master File. It is created with the HOLD command. The APP HOLDMETA command specifies its location.



x
Syntax: How to Specify the Location of a Temporary Master File Under Windows
APP HOLDMETA appname

where:

appname

Is a valid application name.



Example: Specifying the Location of a Temporary Master File Under Windows

The following example specifies a location for a temporary Master File, and assigns a logical name to a physical data source.

1. APP HOLDMETA app1 
2. FILEDEF MKTSALES DISK C:\TMP\MKTSALES.FTM
    TABLE FILE GGSALES
    SUM DOLLARS BY REGION
    ON TABLE HOLD AS MKTSALES FORMAT ALPHA
    END

The numbers listed next to the code correspond with the following notes:

  1. Specifies the location of the Master File in the app1 application directory. WebFOCUS uses the same logical name, MKTSALES, specified in the second line, to name the temporary Master File.
  2. Specifies MKTSALES as the logical name for the physical data source. The HOLD command creates the temporary Master File mktsales.mas and the data source mktsales.ftm.

WebFOCUS