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. |
|
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. |
|
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. |
|
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. |
|
Temporarily alters the system date in order to test a dynamic window. |
|
Defines the start of a 100-year window. |
The following parameters control your Developer Studio environment and the display of your reports in Developer Studio.
Controls the display of informational messages. |
|
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. |
VIEWER MAX VIEWERMULT VIEWER PAUSE VIEWERZOOM |
Controls the Report and Desktop Viewers. |
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. |
|
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. |
|
In Developer Studio, assigns temporary files to a specific directory. |
|
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 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 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 MATCH requests use grouped or ungrouped processing. |
|
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. |
|
Controls whether ON phrases are ignored for fields not referenced in a request. |
|
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. |
|
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. |
|
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.
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 |