Work Files

In this section:

In order to process certain types of requests, FOCUS needs to create temporary work files. As soon as FOCUS is entered, it searches for the disk with the largest available space that you have write access to and will place all work files there. The TEMP DISK parameter may be used to specify a particular disk for the creation of work and extract files. Changing the TEMP DISK will only affect the disk on which new files are created.


Top of page

Example: Specifying a Location for Extract Files

The following places all extract files on the D disk:

SET TEMP DISK = D

Top of page

x
FOCSTACK

Dialogue Manager uses a memory stack for work purposes with a default size of 8K bytes. However, if this is exceeded, FOCUS uses a work file with a fileid of FOCSTACK FOCTEMP.


Top of page

x
FOCSORT

The TABLE, TABLEF, GRAPH, and MATCH commands may require a work file. This file is defined as FOCSORT FOCTEMP on the temporary disk. If the FOCSORT work file is defined to a disk other than the temporary disk, FOCUS respects the allocation.

The FOCSORT file can grow to any size allowed by the operating system running and the available disk space. The user does not have to break a request up to accommodate massive files. With no limit enforced by WebFOCUS, the operating system provides whatever warning and error handling it has for the management of a FOCSORT file that exceeds its limits.


Top of page

x
FOCSML

When Financial Modeling Language is used, a work area with the fileid FOCSML FOCTEMP is created.


Top of page

x
FOCPOST

If Financial Modeling Language options POST or PICKUP are used, a sequential output file will be defined as FOCPOST FOCTEMP.


Top of page

x
REBUILD

The REBUILD command options REBUILD and REORG require that a work file be defined under the ddname REBUILD. (See the Maintaining Databases manual for detailed information on the REBUILD command.) All REBUILD options require a Master File for the data source being rebuilt, a data source to process, and a REBUILD work file. In addition, the REORG load phase requires a new data file for the reorganized FOCUS data sources.

The sequential output file will be defined as

REBUILD FOCTEMP x4

where x is the letter of the disk with the greatest amount of free space to which you can write.

The INDEX option of REBUILD will use the sequential files SORTIN and SORTOUT. The REBUILD option, INDEX, requires an external sort package in the form of a TXTLIB. This sort package should be specified in a GLOBAL TXTLIB statement before REBUILD INDEX is used. See the CMS Installation Guide for further details.

When REBUILD INDEX is invoked, FOCUS searches all TXTLIBs specified in the current GLOBAL TXTLIB statement. If the sort is not found, FOCUS issues the following CMS command to search for the sort again:

GLOBAL TXTLIB sortlib

where sortlib is your library that contains sort routines. If the sort is still not located, the search is terminated and control is returned to the user with the message:

SORT COMPLETED. RETURN CODE 16

You can only REBUILD one partition of a partitioned data source at one time. You must explicitly define the file containing the partition to use in the REBUILD request. If you are rebuilding a data source larger than one gigabyte, you must have enough TEMP space available, or REBUILD in sections to a new file, which is the recommended technique.


Top of page

x
EQFILE

This file is used for storing regression equations from ANALYSE. The default fileid is EQFILE FOCEXEC.


Top of page

x
TABLTALK

This file is used for storing the procedure to be executed from within TableTalk. The fileid is TABLTALK FOCEXEC.


Top of page

x
SET PRINT

To send output to a file when the PRINT parameter is set to OFFLINE, define the file to ddname OFFLINE using a FILEDEF command after the offline has been closed with the OFFLINE CLOSE command.



Example: Sending Output to a File

The following command sends further report output to the file EMPL OUTPUT A with a fixed-length record format and a record length of 80 bytes:

OFFLINE CLOSE
FILEDEF OFFLINE DISK EMPL OUTPUT A (RECFM F LRECL 80

Information Builders