In this section: |
This topic lists the types of tasks that can be accomplished, and the SET parameters that allow you to perform these tasks. If a single parameter applies to more than one activity, it appears in more than one category. For more detailed descriptions, as well as the syntax for each parameter, see SET Parameter Syntax.
The following are the types of tasks performed with SET parameters:
Affects the way calculations are performed in FOCUS. | |
Determines the way data is stored and processed. | |
Controls the way dates are processed and displayed in reports. | |
Controls the processing and display of graphs. | |
Affects the memory and optimization of your application. | |
Determines the content and processing of a request. | |
Affects the display of a report. | |
Controls users access to data sources and procedures. | |
Specifies the options for display in your terminal. |
The following parameters control the behavior of calculations in FOCUS.
Determines the ratio of aggregation based on retrieved records and the final size of the answer set. | |
Specifies the punctuation used in numerical notation. | |
Controls the compilation of expressions. | |
Specifies precision of numeric values in Dialogue Manager -SET commands to calculate accurate numeric variable values. | |
Controls compilation of MODIFY calculations. | |
Controls the level of verification applied to DEFINE FUNCTION arguments and Information Builders-supplied function arguments. | |
Determines whether an Information Builders-supplied function or a locally-written function with the same name used. |
The following parameters determine the way data is stored and processed.
Accepts blank or zero values for fields with ACCEPT commands in the Master File. | |
Enables system-determined blocking for HOLD files written to DASD. | |
Controls the FIELDNAME attribute in a HOLD Master File. | |
Expands the default format of COUNT fields from a five byte integer to a nine byte integer. | |
Specifies the order of the date components (month/day/year) when date-time values are entered in a formatted-string or translated-string format. | |
Compiles virtual fields into machine code to improve performance. | |
Controls whether HOLD Files in FOCUS format are created directly. | |
Controls the use of strict processing for date-time fields. | |
Activates the data source that contains information for the currency you want to convert. | |
Controls the use of long and qualified field names. | |
Enables two-gigabyte FOCUS data sources. | |
Automatically allocates FOCUS files. | |
Determines the default CACHE size in 4K pages when HiperFOCUS is activated. | |
Determines the permissible number of extents for HiperFOCUS. | |
Is the maximum number of 4K pages in an individual hiperspace. | |
Activates HiperFOCUS. | |
Installs or disables HiperFOCUS. | |
Enables processing of user interface commands such as SET HIPERFOCUS. | |
Is the number of 4K pages to aggregate for hiperspace. | |
Controls missing values propagated to a HOLD file. | |
Determines the default format for HOLD files. | |
Determines what fields in a report request are included in the HOLD file. | |
Distinguishes between missing data and default data (zeros or blanks) in a HOLD file. | |
Determines if comments and DBA information are included in HOLD Master Files. | |
Packages HTML and DHTML reports together with image files into a single web archive document (.mht file). | |
Is the indexing scheme used for indexes. | |
Controls whether a virtual field created for a host or joined structure is retained after a JOIN command is run. | |
Enables use of blank delimited (Fusion) Master File syntax, and provides increased enforcement of syntax rules in comma delimited Master File syntax. | |
Enables you to change the number of data exceptions allowed before the session is terminated. | |
Specifies the maximum length of a record described with the Master File OCCURS attribute. | |
Displays a warning message when the cardinality of a dimension exceeds a specified value. | |
Enables retrieval of output from an MDI file without reading the data source. | |
Displays messages about the progress of an MDI build. | |
Determines whether a block is read more than once when reading or writing to a file. | |
Enables creation of a variable-length comma or tab delimited HOLD file that differentiates between a missing value and a blank string or zero value. | |
Determines whether the record length, LRECL, is set to the current setting of LRECL=0, or the older setting of LRECL=512. | |
Enables retrieval of comma delimited files created by a PC application or HOLD FORMAT COM command. | |
Specifies the prefix of existing data sets automatically allocated by FOCUS. | |
Specifies the qualifying character to be used in qualified field names. | |
Saves a Master File to memory after it has been used in a request. | |
Activates the Absolute File Integrity feature. | |
Controls the use of "shift" strings. | |
See Simultaneous Usage Reference Manual for z/OS. | |
See Simultaneous Usage Reference Manual for z/OS. | |
In z/OS, gathers more pages to fill a track before reading or writing the pages to disk. | |
Packages multiple EXL2K files into a single file. | |
Specifies what day of the week is the start of the week. | |
Used for communication between 3270 terminals and the operating system. | |
Specifies the minimum width for format WP output files. | |
Controls the retrieval of data when previewing a report. | |
Enables the use of XFOCUS data sources in addition to FOCUS data sources. | |
Defines the number of pages of memory to use as buffers for XFOCUS data sources. |
The following parameters control the way dates are processed and displayed in reports.
Specifies which days are considered business days and which are not. | |
Controls the display of date format fields that contain the value zero. | |
Activates year 2000-compliant versions of date subroutines. | |
Sets date and time in reports. | |
Defines a default century for your application. | |
Specifies the holiday file from which to retrieve dates that are considered holidays. | |
Avoids the truncation of leading zeros. | |
Temporarily alters the system date in order to test a dynamic window. | |
Defines the start of a 100-year window. |
The following parameters control the processing and display of graphs. For information about these parameters, see the Creating Reports Manual.
AUTOTICK |
Sets the tick mark intervals for graphs. |
BARNUMB |
Places summary numbers at the end of bars on bar charts, or slices on pie charts. |
BARSPACE |
Specifies the number of lines separating the bars on bar charts. |
BARWIDTH |
Specifies the number of lines per bar on bar charts. |
BSTACK |
Specifies whether bar chart bars are stacked or placed side by side. |
DEVICE |
Specifies the plotting device or terminal to be used. |
FRAME |
For GDDM graphics, indicates if you want a frame around your graph. |
GCOLOR(or GRIBBON) |
Depending on device type, determines black and white or color patterns or ribbons used. |
GMISSING |
Specifies whether variables with the value specified in GMISSVAL are to be ignored. |
GMISSVAL |
Specifies the variable value that represents missing data. |
GPROMPT |
Specified whether FOCUS should prompt for graph parameters. |
GRIBBON |
Same as GCOLOR. |
GRID |
Draws a grid of parallel horizontal lines at the vertical class marks on the graph. |
GTREND |
Specifies the use of basic linear regression to alter the X and Y axis values in a SCATTER graph. |
HAUTO |
Performs automatic scaling of the horizontal axis for the given values. |
HAXIS |
Specifies the width, in characters, of the horizontal axis. |
HCLASS |
Specifies the horizontal interval mark when AUTOTICK is OFF. |
HISTOGRAM |
Draws a histogram instead of a curve when the values on the horizontal axis are not numeric. |
HMAX |
Sets the maximum value on the horizontal axis when automatic scaling is not used (HAUTO=OFF). |
HMIN |
Sets the minimum value on the horizontal axis when automatic scaling is not used (HAUTO=OFF). |
PAUSE |
Specifies whether there is a pause for paper adjustment on the plotter after the request is executed. |
PIE |
Specifies a pie chart. |
PLOT |
Specifies the width and height settings for certain devices. |
|
Specifes whether the graph is printed or displayed on the terminal. |
TERM[INAL] |
Specifies the plotting device or terminal to be used. |
VAUTO |
Performs automatic scaling of the vertical axis for the given values. |
VAXIS |
Specifies the length of the vertical axis, in lines. |
VCLASS |
Specifies the vertical interval mark when AUTOTICK is OFF. |
VGRID |
Draws a grid at the horizontal and vertical class marks of the graph. |
VMAX |
Sets the maximum value on the vertical axis when automatic scaling is not used (VAUTO=OFF). |
VMIN |
Sets the minimum value on the vertical axis when automatic scaling is not used (VAUTO=OFF). |
VTICK |
Sets the vertical axis interval mark when AUTOTICK is OFF. |
VZERO |
Treats missing values on the vertical axis as zeros. |
The following parameters control the memory and optimization of your application.
Retrieves data faster by automatically taking advantage of indexed fields in a FOCUS data source. | |
Dynamically selects an optimal retrieval path. | |
Determines when FOCUS stops the search for a key field specified in a WHERE or IF test. | |
Specifies the number of pages of memory used for data source buffers. | |
Stores FOCUS data source pages in memory and buffers between the data source and BINS. | |
Controls the compilation of expressions. | |
Compiles virtual fields into machine code to improve performance. | |
Passes the estimated number of records to be sorted in the request. | |
Enables keyed retrieval from a fixed format sequential file such as a HOLD file. | |
Specifies the amount of space, in thousands of bytes, used by FOCUS commands waiting for execution. | |
Records the last 20 events that the FOCUS Database Server performed. | |
Is used for debugging FOCUS Database Server problems. | |
This parameter is no longer functional. FOCUS is fully LE compliant, and all FOCUS applications must be LE compliant | |
Tells FOCUS where to send line mode output. | |
Enables the SQL Translator to generate TABLEF commands instead of TABLE commands. | |
Keeps Master Files on a FOCUS Database Server open between requests. | |
Assigns temporary files to a specific disk on z/VM. | |
Enables you to offload specific categories of FOCUS processing to a zIIP specialty engine. |
The following parameters affect the content or processing of a report.
Handles missing segment instances in a report. | |
Controls the display of a row of data that contains an invalid date format. | |
Controls the FIELDNAME attribute in a HOLD Master File. | |
Avoids creating the internal matrix based on the features used in the query. | |
Specifies which days are considered business days. | |
Generates a report containing all combinations of non-related data instances in a multi-path request containing a PRINT or LIST command. | |
Specifies punctuation used in numerical notation. | |
Displays a leading zero in decimal-only numbers. | |
Controls whether the missing attribute is propagated to reformatted fields in a report request. | |
Controls the compile of expressions. | |
Controls the display of date format fields that contain the value zero. | |
Activates year 2000-compliant versions of date subroutines. | |
Sets date and time in a report. | |
Defines a default century for your application. | |
Defines a default value for the &ECHO variable for your application. | |
Controls the output generated when a report request retrieves zero records. | |
Terminates a request and returns a message when an error is encountered. | |
Passes the estimated number of records to be sorted in the request. | |
Specifies the language used for Microsoft® Excel requests. This language must be the same as the language of Excel on the browser machine. | |
Enables aggregation in an external sort. | |
Enables you to use an external sort to create HOLD files. | |
Activates Structured HOLD Files for a request. | |
Activates the external sorting feature. | |
Controls the use of long and qualified field names. | |
Specifies a file to be used, by default, in commands. | |
Activates declared filters. | |
Suppresses warning message FOC 144, which reads "Warning Testing in Independent sets of Data." | |
Allows you to include the same value of a FOR field in multiple rows of the FML matrix. | |
Controls missing values propagated to a HOLD file. | |
Includes the TITLE and ACCEPT attributes from the original Master File in the HOLD Master File. | |
Ensures proper alignment of report output by correcting for lagging (missing) values. | |
Controls whether a virtual field created for a host or joined structure is retained after a JOIN command is run. | |
The LANG[UAGE] parameter specifies the National Language Support (NLS) environment. It sets the language of server error messages and can also be used to set the language of report titles if the Master File Description contains alternate language TITLE attributes. | |
Avoids the truncation of leading zeros. | |
Controls the display of informational messages. | |
Controls whether a parent segment is included in report output when selection tests are done on independent paths. | |
Determines the character string that indicates missing data in a report. | |
Pauses before displaying a FOCUS report on the terminal. | |
Assigns a function to a PF key. | |
Determines if an extra space is appended to each record of a PDF output file to facilitate proper file transfer between Windows and UNIX. | |
Specifies the qualifying character to be used in qualified field names. | |
Saves the matrix from your request to protect it from being overwritten when using Dialogue Manager commands. | |
Tells FOCUS which sort package is installed at your site. | |
Permits the combination of fields with and without prefix operators on summary lines in one request. | |
Allows users to choose the answer set display order when using an external sort to perform aggregation of alphanumeric or smart date formats. | |
Uses predefined column titles in the Master File as column titles in report output. |
The following parameters affect the layout and display of a report.
Controls underlining of ACROSS objects on report output. | |
Reduces the number of report lines within each sort group when a request uses the PRINT command and an ACROSS phrase. | |
Specifies a default location where your browser searches for relative URLs referenced in the HTML documents created by FOCUS. | |
Clarifies relationships within an FML hierarchy by indenting the captions (titles) of values at each level. | |
Sets the bottom boundary for report contents on a page in a styled report. | |
Displays every instance of a vertical (BY) sort field value in a report. | |
Controls the repetition of BY fields on panels. | |
Scrolls report headings and footings along with the report contents. | |
Displays a leading zero in decimal-only numbers. | |
Enables you to scroll by column within the panels of a report provided that the report is wider than the screen width. | |
Enables you to combine multiple reports into a single PDF or PS file to create a compound report. | |
Links an HTML report to an external Cascading Style Sheet (CSS) file in order to style the report. | |
Sets a currency symbol to display on the report output when a numeric format specification uses the M or N display options. | |
Suppresses blank lines automatically generated before subheadings, subfootings, and subtotals. | |
Controls whether columns for multiple display commands are spread out or stacked on top of each other. | |
Assigns a page number to the first page of output. | |
Creates an inline Cascading Style Sheet command in the HTML page that displays the report output. | |
Specifies the National Language Support (NLS) environment. Sets the language of server error messages. Can also be used to set the language of report titles if the Master File Description contains alternate language TITLE attributes. | |
Displays a grid in the report output, which enables you to evaluate the correct placement of data and objects during your report design. This option is applicable only when using the PDF, PS, or DHTML report output. | |
Sets the left boundary for report contents on a page in a styled report. | |
Sets the maximum number of lines of printed output that appear on a page, from the heading at the top to the footing on the bottom. The OFFLINE-FMT parameter determines the format of printed report output generated from a request. | |
Determines the format of report output. (Applies to WebFOCUS only.) | |
Specifies the page orientation for styled reports. | |
Controls the numbering of output pages. | |
Specifies the page size for StyleSheets. | |
Sets the maximum line width of a report panel. | |
Specifies the length of paper for printed output. | |
Specifies the report output destination. | |
Specifies enhancements to display alternatives. | |
Coordinates the paper source used by a PostScript printer with the PAGESIZE parameter setting. | |
Uses qualified column titles in report output when duplicate field names exist in a Master File. | |
Allows direct control over the frequency with which REBUILD issues messages. | |
Includes lines containing a value created with RECAP when counting the number of lines per page for printed output. | |
Sets the right boundary for report contents on a page. | |
Preserves leading and internal blanks in HTML and EXL2K report output. | |
Sets the number of spaces between columns in a report. | |
Determines the column width in report output. | |
For large report output, displays output in multiple HTML tables where each table is a separate report page. | |
Controls the format of report output by accepting or rejecting StyleSheet parameters. | |
Includes the HTML code <BASE TARGET="framename"> in the heading of the HTML file that is displayed in your browser. | |
Selects the terminal type. | |
Sets the top boundary on a page for report output. | |
Displays extended currency symbols on TSO. | |
Specifies the unit of measure for page margins, column positions, and column widths. | |
Encloses CRTFORM display fields in @ signs. |
The following parameters specify user access to data sources and procedures.
Controls whether password validation is case sensitive. | |
Enables user access to a data source or stored procedure protected by Information Builders security. | |
The PERMPASS parameter establishes a user password that remains in effect throughout a session or connection. | |
In FOCUS, enables user access to a data source or stored procedure protected by Information Builders security. |
The following parameters specify options for display in your terminal.
Is the PC display mode selection. | |
Enables the use of extended terminal attributes. | |
Automatically displays the Hot Screen PF key legend at the bottom of the Hot Screen report. | |
Generates a solid border on the screen for full-screen mode. | |
Selects the Hot Screen facility. | |
Suppresses all output messages to the terminal. |
Â
Information Builders |