|
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 user 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 numeric notation.
Controls the compilation of expressions.
Specifies precision of numeric values in Dialogue Manager -SET commands to calculate accurate numeric variable values.
Takes advantage of decimal-based precision numbers for all numeric processing for floating point numbers.
Sets a default value, either SOME or ALL for MISSING ON in DEFINE and COMPUTE.
Determines whether the IF expression in IF-THEN-ELSE tests is checked for missing values.
Controls compilation of MODIFY calculations.
Sets the partition size for statistical functions.
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 is 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.
Controls the FIELDNAME attribute in a HOLD Master File.
Enables system-determined blocking for HOLD files written to DASD.
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.
Controls whether the characters $ and $* are treated as wildcard characters or normal characters in selection criteria.
Activates the data source that contains information for the currency you want to convert.
Controls the use of long and qualified field names.
Automatically allocates FOCUS files.
Activates HiperFOCUS.
Installs or disables HiperFOCUS.
Controls whether trailing blanks are retained when the output is held in a delimited format.
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).
Encodes data within HTML output.
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.
Determines how rank numbers are assigned in a request when multiple data values fall into the same rank category.
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 .
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 a minimum width for format WP output files.
Controls the retrieval of data when previewing a report.
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.
Specifies the order of date components.
Specifies the separator for date components.
Controls the display of a base date
Activates year 2000-compliant versions of date subroutines.
Sets date and time in reports .
Defines a default century for your application.
Controls whether translated dates are sent as date values with format masks instead of text values.
Specifies the holiday file from which to retrieve dates that are considered holidays.
Avoids the truncation of leading zeros.
Specifies the separator for time components for the &TOD variable.
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.
Sets the tick mark intervals for graphs.
Places summary numbers at the end of bars on bar charts, or slices on pie charts.
Specifies the number of lines separating the bars on bar charts.
Specifies the number of lines per bar on bar charts.
Specifies whether bar chart bars are stacked or placed side by side.
Specifies the plotting device or terminal to be used.
For GDDM graphics, indicates if you want a frame around your graph.
Depending on device type, determines black and white or color patterns or ribbons used.
Specifies whether variables with the value specified in GMISSVAL are to be ignored.
Specifies the variable value that represents missing data.
Specified whether FOCUS should prompt for graph parameters.
Same as GCOLOR.
Draws a grid of parallel horizontal lines at the vertical class marks on the graph.
Specifies the use of basic linear regression to alter the X and Y axis values in a SCATTER graph.
Performs automatic scaling of the horizontal axis for the given values.
Specifies the width, in characters, of the horizontal axis.
Specifies the horizontal interval mark when AUTOTICK is OFF.
Draws a histogram instead of a curve when the values on the horizontal axis are not numeric.
Sets the maximum value on the horizontal axis when automatic scaling is not used (HAUTO=OFF).
Sets the minimum value on the horizontal axis when automatic scaling is not used (HAUTO=OFF).
Specifies whether there is a pause for paper adjustment on the plotter after the request is executed.
Specifies a pie chart.
Specifies the width and height settings for certain devices.
Specifes whether the graph is printed or displayed on the terminal.
Specifies the plotting device or terminal to be used.
Performs automatic scaling of the vertical axis for the given values.
Specifies the length of the vertical axis, in lines.
Specifies the vertical interval mark when AUTOTICK is OFF.
Draws a grid at the horizontal and vertical class marks of the graph.
Sets the maximum value on the vertical axis when automatic scaling is not used (VAUTO=OFF).
Sets the minimum value on the vertical axis when automatic scaling is not used (VAUTO=OFF).
Sets the vertical axis interval mark when AUTOTICK is OFF.
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.
Controls the number of loop iterations allowed in Dialogue Manager.
Controls the number of lines allowed in FOCSTACK.
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.
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 numeric notation.
Displays a leading zero in decimal-only numbers.
Controls ordering of alphanumeric values.
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 .
Controls whether DBA restrictions are treated as report filters or are added to the join conditions.
Controls whether the expression generated by the DB_INFILE function for use against a relational data source is optimized.
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 application server to be used to zip the file components that comprise an EXCEL 2007 file (.xlsx).
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 FOC144, 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.
Controls whether strict equality is required or partial key joins are supported for record-oriented adapters. JOINLM is a synonym for JOIN_LENGTH_MODE.
Ensures proper alignment of report output by correcting for lagging (missing) values. Also enables joins between fields with different numeric data types.
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 FOCUS 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 MATCH requests use grouped or ungrouped processing.
Determines the character string that indicates missing data in a report.
Controls whether ON phrases are ignored for fields not referenced in a request.
Pauses before displaying a FOCUS report on the terminal.
Controls the partition size for statistical functions.
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.
Sets the phonetic algorithm to use with the PHONETIC function.
Controls processing of reports that use the PRINT command in conjunction with multiple DST operators.
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.
Controls how tests against missing cross-referenced segment instances are processed in a left outer join.
Tells FOCUS which sort package is installed at your site.
Controls whether to employ in-memory sorting with decreased use of external memory.
Controls the amount of internal memory available for sorting.
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 column titles on report output. TITLELINE is a synonym.
Reduces the number of report lines within each sort group when a request uses the PRINT command and an ACROSS phrase.
Controls whether ACROSS titles display above or to the left of ACROSS values.
Controls the display of ACROSS column titles when there is only one displayed field for an ACROSS group.
Alternates the background color by line for reports that use positioned drivers, for example PDF, DHTML, PPT, and PPTX.
Controls resizing of HTML report output to fit its window.
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 a sort field on every row, column, or both 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.
Defines the position of the currency symbol relative to the monetary number.
Defines the ISO code for the currency symbol to use.
Defines what will happen when the currency symbol cannot be displayed by the code page in effect.
Sets a currency symbol to display on the report output when a numeric format specification uses the M or N display options.
Sets the characters to display on the report output when a numeric format specification uses the :D or :d display options.
Sets the characters to display on the report output when a numeric format specification uses the :E or :e display options.
Sets the characters to display on the report output when a numeric format specification uses the :F display option.
Sets the characters to display on the report output when a numeric format specification uses the :G display option.
Sets the characters to display on the report output when a numeric format specification uses the :L or :l display options.
Sets the characters to display on the report output when a numeric format specification uses the :Y or :y display options.
Sets the page length for PAGESIZE=CUSTOM.
Sets the page width for PAGESIZE=CUSTOM.
Eliminates blank lines from the report output.
Controls whether columns for multiple display commands are spread out or stacked on top of each other.
Prevents visual overflow on reports.
Assigns a page number to the first page of output.
Hides ACROSS columns containing only null values.
Creates an inline Cascading Style Sheet command in the HTML page that displays the report output.
Determines whether to embed images and graphs directly into an HTML or DHTML .htm file.
Specifies the National Language Support (NLS) environment. Sets the language of FOCUS 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.
Specifies the page orientation for styled reports.
Changes the character that displays in a numeric report column when the column does not have enough space for the value.
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.
Controls whether fields prefixed with PCT., RPCT., and PCT.CNT. display with the format of the original field or with a percent sign.
Generates readable and translatable column titles for prefixed fields on reports.
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.
Controls the format of report output by accepting or rejecting StyleSheet parameters.
Controls whether summary lines display above or below the data.
Selects the terminal type.
Controls underlining of column titles. ACROSSLINE is a synonym.
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.
Controls the source of access restrictions in a multi-file structure.
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 |