New Features

Describes the new enhancements in Version 20.0 of
CA SQL-Ease® for DB2 for z/OS
.
casqle20
The following list provides a high-level summary of the new features and enhancements that have been delivered to date in Version 20.0 for Version 20.0 of
CA SQL-Ease® for DB2 for z/OS
:
To ensure availability of all features and fixes, we recommend that you install all available maintenance. To download and receive maintenance automatically, use CA SMP/E Receive Order. To view a list of available solutions and fixes, select the link for PTFs since GA on the CA Database Management Solutions for DB2 for z/OS Maintenance Grid (login required).
For a list of enhancements for all the CA Database Management Solutions for DB2 for z/OS, click here. To request product enhancements, contact a product manager or post your request in the "Ideation" section of the Db2 Tools Community.
DBM 20 IR 8 is the last incremental update for Version 20.0. New features and fixes are no longer bundled in incremental PTFs. Instead, we have transitioned to a continuous delivery release model that provides individual PTFs for new product features and product fixes. For more information, see Transition to Continuous Delivery.
Db2 12 Support
IBM Db2 12 for z/OS function levels V12R1M100, V12R1M500, and V12R1M
nnn
are now supported.
Version 20.0 of 
CA SQL-Ease® for DB2 for z/OS
supports the IBM Db2 12 Continuous Delivery Model, which introduces new features in the maintenance stream for faster adoption. Customers who are moving to Db2 12 should upgrade to this version. In Version 19.0,
only
V12R1M100 for migration from Db2 11 and new function level V12R1M500 are supported for Db2 12.
Db2 12 SQL DML Syntax Support
The following Db2 12 SQL DML syntax support is now provided:
  • BETWEEN temporal period clause in searched DELETE and UPDATE statements
  • FETCH NEXT in SUBSELECT, FULLSELECT, and SELECT INTO statements
  • FETCH in searched DELETE statements
  • LIMIT as an alternative to FETCH or FETCH OFFSET
  • LISTAGG in built-in functions
  • OFFSET in SUBSELECT, FULLSELECT, and SELECT INTO statements
  • Alternate names for preexisting built-in functions (introduced in function level V12R1M506):
    Preexisting Function Name
    Alternate Name
    COVARIANCE or COVAR
    COVAR_POP
    CHARACTER_LENGTH
    CHAR_LENGTH
    CLOB
    TO_CLOB
    HASH_MD5, HASH_SHA1, or HASH_SHA256
    HASH
    LEFT
    STRLEFT
    POSSTR
    STRPOS
    POWER
    POW
    RAND
    RANDOM
    RIGHT
    STRRIGHT
    TIMESTAMP_FORMAT or TO_DATE
    TO_TIMESTAMP
  • Built-in scalar functions (introduced in function level V12R1M505):
    • DECRYPT_DATAKEY_BIGINT
    • DECRYPT_DATAKEY_BIT
    • DECRYPT_DATAKEY_CLOB
    • DECRYPT_DATAKEY_DBCLOB
    • DECRYPT_DATAKEY_DECIMAL
    • DECRYPT_DATAKEY_INTEGER
    • DECRYPT_DATAKEY_VARCHAR
    • DECRYPT_DATAKEY_VARGRAPHIC
    • ENCRYPT_DATAKEY
  • Global variables:
    • CATALOG_LEVEL
    • DEFAULT_SQLLEVEL
    • MERGE USING
      table-reference
      as an alternate way of specifying source data
    • PRODUCTID_EXT
    • TEMPORAL_LOGICAL_TRANSACTION_TIME
    • TEMPORAL_LOGICAL_TRANSACTIONS
    • REPLICATION_OVERRIDE (introduced in function level V12R1M503)
  • Obfuscated statement text in CREATE TRIGGER statements
  • Operands in row-value expressions for basic predicates:
    • < (less than)
    • > (greater than)
    • <= (less than or equal to)
    • >= (greater than or equal to)
Db2 12 EXPLAIN Table Support
The short and long access path reports now support the new Db2 12 values in the following PLAN_TABLE columns:
  • PRIMARY_ACCESSTYPE
  • COLUMN_FN_EVAL
  • QBLOCK_TYPE
In addition, the explain table auto-creation function and the Create Explain/Input Tables option now support the new Db2 12 FUNCTION_LEVEL column in the DSN_STATEMNT_TABLE.
Db2 11 Syntax Support
The following Db2 11 support is now provided:
  • Special register support:
    • CURRENT ACCELERATOR
    • CURRENT QUERY ACCELERATION WAITFORDAT
  • Correlation clause is now optional for nested table expression, XMLTABLE expression, and collection-derived table.
  • Built-in scalar functions SOAPHTTPNC and SOAPHTTPNV
SQL that contains this syntax can now be processed successfully.
Db2® Spatial Extender Support
SQL that contains the predicate selectivity clause in search conditions is now supported.
SQL that contains this syntax can now be processed successfully.