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. |
|
Affects the behavior of web-specific tasks in your application. |
|
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. |
The following parameters control the behavior of calculations in WebFOCUS.
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. |
|
Determines whether the IF expression in IF-THEN-ELSE tests is checked for missing values. |
|
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. |
|
PACKPOS |
In WebFOCUS, defines the positive character value for packed fields. |
In WebFOCUS, determines the behavior of a calculation when dividing by zero. |
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. |
|
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. |
|
Allows you to access resources with an alias other than /ibi_apps/ibi_html. |
|
Translates field and segment names in a business view to their corresponding names in the original Master File for request processing. |
|
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. |
|
Controls whether a virtual field created for a host or joined structure is retained after a JOIN command is run. |
|
Enables you to change the number of data exceptions allowed before the session is terminated. |
|
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. |
|
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 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. |
|
Determines if the temporary files created during a WebFOCUS connection are retained after the connection is closed. |
|
Packages multiple EXL2K files into a single file. |
|
Specifies what day of the week is the start of the week. |
|
Specifies a minimum width for format WP output files. |
|
Controls the retrieval of data when previewing a report. |
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 date format fields that contain the value zero. |
|
Activates year 2000-compliant versions of date subroutines. |
|
Sets date and time in reports and controls the format in which CREATE SYNONYM creates date-time columns in a Master File. |
|
Defines a default century for your application. |
|
Controls whether translated dates are sent as date values with format masks instead of text values. |
|
Both UNIX and WebFOCUS support uppercase, lowercase, and mixed-case file names and directories. Since lowercase is the default in UNIX environments, WebFOCUS offers a way to automatically convert file names and directories to lowercase. |
|
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 affect the behavior of web-specific tasks in WebFOCUS.
&&APP_PERMIT |
Enables you to create and update applications and files under the APPROOT directory. |
Specifies a default location where your browser searches for relative URLs referenced in the HTML documents created by WebFOCUS. |
|
Runs and executes drill downs remotely. |
|
Includes JavaScript or VBScript files in an HTML report. |
|
Controls whether the WebFOCUS Viewer displays an All Pages button. |
|
Controls whether the WebFOCUS Viewer displays a Close button. |
|
Controls whether the WebFOCUS Viewer Close message displays when the Close option is clicked |
|
In WebFOCUS, enables on-demand paging, and invokes the WebFOCUS Viewer. |
|
Controls whether the WebFOCUS Viewer displays a Help button. |
|
Allows an HTML page to be displayed when the WebFOCUS Viewer is closed. |
|
Allows the user to open the WebFOCUS Viewer in a target frame. |
|
Defines the title text for the WebFOCUS Viewer window. |
The following parameters control your Developer Studio environment and the display of your reports in Developer Studio.
Controls the display of informational messages. |
|
Determines the format of printed report output generated from a request submitted from the Command Console or created in the Text Editor. |
|
Specifies the page size for printed output. |
|
Determines whether report output is sent to your screen or to the printer. |
|
Controls the use of shift strings. |
|
FUSE |
Specifies files that contain user-defined functions. |
MORE |
Controls scrolling. ON cases display to pause when screen is full. OFF allows continuous scrolling. |
Turns off warning messages. |
|
SORT |
Sets name of file for foreign languages. The default is English. |
Provides printing enhancements. |
|
VIEWER MAX VIEWERMULT VIEWER PAUSE VIEWERZOOM |
Controls the Report and Desktop Viewers. |
Assigns temporary files to a specific directory. |
The following parameters control the processing and display of graphs.
Sets a chart to either three dimensions or two dimensions. |
|
Sets the graph engine used for rendering graphs in active technologies reports. it only has an effect when used with FORMAT AHTML or other active formats (APDF or FLEX). |
|
Controls resizing of HTML5 graphs to fit their containers. |
|
Sets the tick mark intervals for graphs. |
|
Places summary numbers at the end of bars on bar charts, or slices on pie charts. |
|
BSTACK |
Specifies whether bar chart bars are stacked or placed side by side. |
Controls whether the heading or footing text is rendered within, or outside, the chart image. |
|
Controls whether WebFOCUS default settings or the graph API default settings are in effect. |
|
As of WebFOCUS 8.0, this parameter has been deprecated. You can use InfoAssist to edit charts. For information, see the WebFOCUS InfoAssist User’s Manual. |
|
Determines the version of the WebFOCUS graph engine that is used. |
|
Creates a GIF file of the graph by sending an HTTP request to a servlet. |
|
Specifies whether to create multiple graphs or a single graph when a request has multiple sort fields. |
|
Specifies how many sort fields are used to generate multiple graphs when GRMERGE is set to ADVANCED. |
|
Draws a grid of parallel horizontal lines at the vertical class marks on the graph. |
|
Places an output graph in an HTML table of a specified width, in cells. |
|
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). |
|
Stacks the bars on a histogram instead of placing them side by side. |
|
Sets the horizontal axis interval mark when AUTOTICK is OFF. |
|
Specifies a graph style. |
|
When a graph is rendered as OLAP, generates a three-dimensional graph that reflects all output data from a request containing both a BY and an ACROSS phrase. |
|
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 WebFOCUS 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. |
|
Limits the number of records retrieved. |
|
Enables the SQL Translator to generate TABLEF commands instead of TABLE commands. |
|
In WebFOCUS, assigns temporary files to a specific directory. |
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. |
|
Specifies the date when an HTML active report expires. |
|
Specifies the password required to view HTML active report output. |
|
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 and controls the format in which CREATE SYNONYM creates date-time columns in a Master File. |
|
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. |
|
The SET FILECOMPRESS=ON command compresses PDF output files. The compressed PDF file is 25% of the original PDF file size. |
|
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. |
|
Includes JavaScript or VBScript files in an HTML report. |
|
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 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. |
|
Controls whether ON phrases are ignored for fields not referenced in a request. |
|
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. |
|
Enhances the quality of charts embedded into PowerPoint (PPTX) slides. |
|
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. |
|
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. |
|
Turns off warning messages. |
The following parameters affect the layout and display of a report.
Generates HTML report output that is Section 508 compliant. |
|
Generates report output in HTML code that is Section 508 compliant. |
|
Generates PDF report output that is Section 508 compliant. |
|
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. |
|
Enables you to automatically drill down to the next level of a dimension within the body of a report. |
|
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 WebFOCUS. |
|
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 value on every row, column, or both in a report. |
|
Controls the repetition of BY fields on panels. |
|
Displays a leading zero in decimal-only numbers. |
|
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. |
|
Eliminates blank lines from the report output. |
|
Controls whether columns for multiple display commands are spread out or stacked on top of each other. |
|
Creates an Accordion report that expands by column. |
|
Creates an Accordion report that expands by row. |
|
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 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. |
|
Displays report output from right to left for supported formats. |
|
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. |
|
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. |
|
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. |
|
Sets the maximum line width of a report panel. |
|
Specifies printing enhancements. |
|
Enables a pop-up field description in an HTML report when your mouse pointer is positioned over a column title in the report output. |
|
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. |
|
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. |
|
Controls whether summary lines display above or below the data. |
|
Includes the HTML code <BASE TARGET="framename"> in the heading of the HTML file that is displayed in your browser. |
|
Controls underlining of column titles. ACROSSLINE is a synonym. |
|
Sets the top boundary on a page for report output. |
|
Specifies the unit of measure for page margins, column positions, and column widths. |
|
Specifies the orientation of visualization bars for ACROSS columns. |
The following parameters specify user access to data sources and procedures.
&&APP_PERMIT |
Enables you to create and update applications and files under the APPROOT directory. |
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 WebFOCUS, enables user access to a data source or stored procedure protected by Information Builders security. |
|
WebFOCUS |