DB2 QMF for TSO/CICS enhancements
DB2 QMF for TSO/CICS now offers these significant enhancements
to core functionality including:
- User enhancements
-
- Names up to 128 characters in length are supported for Auth
ID, current SQL ID, and table names. Table column names can be up
to 30 characters long. Support is based on whatever length the database
allows. Support includes larger data-entry fields and the display
of names in QMF dialog screens.
- The CALL statement can be issued from the SQL Query panel to
run a DB2 stored procedure. Output parameters will be placed in
QMF substitution variables defined by the user. Result sets will
have all the features of a result set returned from a query.
- Fully integrated support for the CLOB, BLOB and DBCLOB large object
data types has been added. LOB data can be displayed in reports
from tables containing LOB columns.
- A new edit code 'M' displays the associated
column metadata in lieu of column data. Edit code 'M' is
the default edit code for LOB data types.
- A new PRINT command option allows users to suppress carriage control
characters in the report output format when a print device name
is not supplied.
- The size of global variables specified on the Set and Get Global commands
has been extended from 55 to 2000 characters.
- The new global variable DSQEC_SP_RS_NUM allows you to specify
a particular result set if a DB2 stored procedure returns multiple
result sets.
- Several new DB2 UDB for z/OS Version 8 SQLCODES are supported.
- Administrator enhancements
-
- An improved installation process and less post SMP/E installation work
- New global variable DSQEC_CC provides flexibility in setting
the CC (carriage control) keyword.
Publication changes: Installing and Managing DB2 QMF for TSO/CICS refers
only to the z/OS platform. Users should refer to QMF Version 7.2
publications for VM and VSE platform specific information.
