Version 11.2 changes

These are enhancements to QMF Version 11 Release 2.

Enhanced QMF Editor

The QMF Enhanced Editor feature brings creating and editing QMF SQL queries and procedures to a whole new level. For SQL queries, the QMF Enhanced Editor provides customizable highlighting and formatting for SQL syntax, reserved words, functions, and data types. Parenthesis checking is also available.

The Query Assist feature provides table name suggestions, column name and data type information, and suggested column value information. A preview pane is available for immediate SQL results checking.

The QMF Enhanced Editor can be used for QMF linear procedures and procedures with logic. Highlighting similar to that found in the query object is also available.

The QMF Enhanced Editor is accessed from the QMF command line by entering the QMF EDIT command with the EDITOR keyword set to 'EE'. The new DSQEC_EDITOR global variable provides a customizable override of the EDITOR keyword specifications.

Get organized with QMF folders

QMF queries, procedures, forms, and analytics can now be organized into groups called folders.

The LIST, SAVE, and ERASE commands have been updated to operate with the FOLDER keyword, which allows you to view and manipulate QMF objects in a more defined way. By using the SAVE command, you can automatically create a new folder by saving your first object to it. The RENAME command has been updated to rename FOLDER objects and to rename FOLDER references when a QMF object is renamed.

The new DSQEC_CURR_FOLDER global variable allows you to define your own default value for the FOLDER keyword.

QMF Analytics for TSO enhancements

Three new models, Wilcoxon Signed-Rank Test, Mann-Whitney U Test, and F-Test have been added to the statistics modeling capabilities of the QMF Analytics for TSO feature.

The ability to choose columns for use in analytical analyses has been improved with enhanced data type targeting and information. The columns that are shown are based on model requirements; you can see a sample of values such as maximum and minimum to aid in column input to the model.

User-defined mapping capability has been added to QMF Analytics for TSO. OpenGIS WKT map definitions are available in either Db2® tables or exported data sets, which can be read by QMF Analytics for TSO to format user-specific maps. Maps for Africa, North America, South America, and Germany have been added to the existing library of predefined maps.

Saving analytics has been updated to allow listing of existing analytics objects.

SQL enhancements

Enhancements for SQL queries include the following changes:

  • The following special registers can now be set from within a QMF SQL query:
    Specifies the compatibility level support for dynamic SQL.
    Specifies whether a dynamic SQL query uses archived data if the query refers to a table that is archived on an accelerator server.
  • By using the new DSQSFISO program parameter option, scalar date and time functions such as CHAR will now reflect the actual date and time format of the database and not the ISO format precompiler option of QMF, which was the format used in previous releases. The new DSQAO_DATE_FORMAT and DSQAO_TIME_FORMAT global variables inform the user of the default date and time formats used by the database. The new DSQAO_DSQSFISO global variable contains the value of the DSQSFISO program parameter setting.

QMF command and command behavior

Enhancements to QMF commands and command behavior include the following changes:

  • The process of saving database tables, which was traditionally accomplished by using the QMF SAVE DATA command, has been improved for increased performance and reduced storage requirements. By using the new TABLE keyword on the RUN QUERY command, you can now SAVE DATA without having to return and complete a data object. The RUN QUERY with the TABLE keyword operates completely within the database to both retrieve data and insert rows without returning a report to the user.
  • The SPACE keyword has been added to the SAVE DATA, IMPORT TABLE, and RUN QUERY commands (when the TABLE keyword is specified) to allow you to override the SPACE specifications that are usually set in your profile. Specific databases and tablespaces can be targeted for saving data without updating a user's profile.
  • The ACCELERATOR keyword has been added to the SAVE DATA, IMPORT TABLE, and RUN QUERY commands (when the TABLE keyword is specified) to allow the creation of Db2 accelerator-only tables. The new DSQEC_SAV_ALLOWED global variable controls whether an accelerator, traditional tablespace, or both can be used. The new DSQEC_SAV_ACCELNM global variable has been added to provide a default for the ACCELERATOR keyword.
  • A new command, RENAME, has been added to give you the ability to rename Db2 tables or QMF objects in a single step.
  • The QMF EDIT command has been updated to load saved queries and procedures directly from the database rather than requiring that queries and procedures be already located in temporary storage.
  • The new DSQCP_RMV_BLANKS global variable allows you to retain trailing blanks on VARCHAR and VARGRAPHIC columns while using the QMF EDIT TABLE command. Columns that contain relevant trailing blanks will be preserved after editing by the QMF Table Editor.
  • Exporting QMF reports can now be done with no control information. You can use the EXPORT REPORT command with the DATAFORMAT keyword set to the new value 'TEXT' in order to get preallocated data sets that contain formatted QMF reports. The report output is suitable for text attachments or easy reading.

Default form overrides

By using following new the global variables, you can override QMF default form edit codes:

Default formatting can be controlled by global variable settings with no saved customized forms at all, which can reduce the amount of specialized forms in which only edit code changes exist.

Query by example (QBE) enhancements

The QBE interface has been updated to support 128-character owner and table names and 30-byte column names. The DRAW, IMPORT, and EXPORT commands for QBE objects have also been updated to support increased owner, table, and column name lengths.

QBE queries created in releases prior to QMF Version 11 Release 2 can be successfully accessed and executed in QMF Version 11 Release 2. If the QBE query is saved in QMF Version 11 Release 2, it will be reformatted to the new long name structure and no longer accessible in releases prior to QMF Version 11 Release 2. If you wish to avoid converting and replacing an old query, rename the query when you save it. Older release QBE queries that are reformatted during SAVE will result in DSQDEBUG log message 'Old QBE query saved in long-name fmt'. This message is informational only and does not indicate any error.

Application programming support

Documentation about session-cancelling topics within the QMF governor interface has been improved.

QMF administration and serviceability

This release of Db2 QMF includes the following serviceability and administration enhancements:

  • The DSQEC_SAV_ALLOWED global variable allows administrators to control the implementation of the SAVE DATA, IMPORT TABLE, or RUN QUERY to TABLE commands. This global variable controls whether you can save data to traditional tablespaces, an accelerator, or block the use of the commands. The global variable allows you to specify defaults or to override defaults with keyword values.
  • The DSQEC_SPAC_OVRIDE global variable allows administrators to control whether the SPACE parameter can be used to override the Q.PROFILES.SPACE values on SAVE DATA, IMPORT TABLE, or RUN QUERY to TABLE commands.
  • Storage sizes for QMF procedures and queries have been optimized so that a minimal amount of space is used for storage within the QMF catalog.
  • Improved default tracing diagnostics are now produced for default trace situations. QMF release and database connections will be easily discovered in default tracing. QMF trace size controls have been added with the new DSQEC_TRACE_LIMIT global variable .
  • The new 'SHOW SERVICE' command displays service-level information.
  • DSQPNLE panel service-level information can be quickly determined from the 'About QMF' panel, which is accessed from the main help system.

For additional information about any of these enhancements, see the QMF Version 11 Release 2 information in IBM® Knowledge Center at:

Removal of DSQ0EQ24

QMF sample query SAMPLE_SYNONYM, which existed in QMF.SDSQSAPE member DSQ0EQ24, has been removed from the product.