FILESET

The FILESET command sets the paging attributes of a specified fileunit.

Syntax

FILESET fileunit attrib-arg1 exp1 [attrib-argN expN ...]

where:

attrib-arg is one of the following:

BMARGIN

LINENUM

LSIZE

ORIGIN

PAGENUM

PAGEPRG

PAGESIZE

PAGING

PAUSEATPAGEEND

TABEXPAND

TMARGIN

Arguments

fileunit: A fileunit number that is assigned to a file opened in a previous call to the FILEOPEN function or by the OUTFILE command. You can set attributes only for an open file. An attribute argument specifies the file characteristic to change. The attribute must be appropriate for the fileunit specified; otherwise, Oracle OLAP returns an error. You can set several attributes in one FILESET command by listing the attribute name and its new value in pairs.
BMARGIN: Specifies the number of blank lines that make up the bottom margin.
LINENUM: Specifies the current line number. Resets after each pagebreak when PAGING is on; otherwise, keeps incrementing.
LSIZE: Specifies the maximum line length for text output files, or the record length for binary input files.
ORIGIN: Specifies the type of system on which the file was created. See "ORIGIN Attribute".
PAGENUM: Specifies the current page number.
PAGEPRG: Specifies the OLAP DML program that produces page titles and headings when output is paged.
PAGESIZE: Specifies the number of lines on each page.
PAGING: Specifies if the output is formatted in pages.
PAUSEATPAGEEND: Specifies if Oracle OLAP should pause after each page.
TABEXPAND: Specifies if tab characters should be expanded. See "Tab Treatment".
TMARGIN: Specifies the number of blank lines that make up the top margin.
exp: An expression that contains the new value for the attribute being set. The data type of the expression must be the same as the data type of the attribute.

Notes

OUTFILE Command

When you use an OUTFILE filename command, it is easier to set paging attributes for the file by using the regular Oracle OLAP paging options from the command line instead of FILESET. When you prefer FILESET, you can identify the file by simply using the OUTFILEUNIT option. For example, these statements

OUTFILE FILENAME
PAGING = YES

are equivalent to these statements,

OUTFILE FILENAME
FILESET OUTFILEUNIT PAGING YES

Multiple Open File Units

You can have as many files open at the same time as your operating system allows.

Tab Treatment

When you want tab characters in the source file to be expanded when read by FILEGET or FILEREAD, you can specify the TABEXPAND attribute. When TABEXPAND is zero, tab characters will not be expanded. A value greater than 0 indicates the distance, in bytes, between tab stops. The default value of TABEXPAND is 8.

ORIGIN Attribute

The default value of the ORIGIN attribute reflects the system you are currently working on, so you must set ORIGIN when the file originated on a different system. The setting of ORIGIN affects how data reading statements interpret the files. For example, data reading statements use this information to decide whether bytes of binary data need to be reversed, and so forth. Table 13-2, "Values for ORIGIN Clause of FILESET" will help you make the right choice. When your system is not listed, try using PC or HP as the value of ORIGIN. When one value does not work, the other one should.

Table 13-2 Values for ORIGIN Clause of FILESET

Value	Hardware or Operating System
ALPHA	Any DEC workstation using an Alpha processor
AVMS	A DEC Alpha processor running on VM
HP	HP MPE XL
HPS700	HP Series 700 Workstation
HPS800	HP Series 800 Workstation
IBMPC	An Intel processor running DOS, Windows, or Windows N
INTEL5	Any Intel5 processor running Unix
MIPS	Any MIPS machine
MVS	IBM MVS/TSO
NTALPHA	A DEC Alpha processor running Windows NT
PC	An Intel processor running DOS, Windows, or Windows NT
RS6000	Any IBM RS6000 processor running IBM AIX
SOLARIS2	Any workstation running Solaris2
SUNOS4	Any workstation running SunOS4
VAX	VAX VMS (floating point in G format only)
VM	VM/CMS

Examples

Example 13-14 Setting Paging for a Report

When you are sending output to a report in a disk file, you might set the following attributes to indicate that the report is organized in pages and that the first page is 1.

DEFINE fil.unit INTEGER
fil.unit = FILEOPEN('REPORT' WRITE)
FILESET fil.unit PAGING YES PAGENUM 1