Db2 for z/OS and its ecosystem

Db2 for z/OS and its ecosystem

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

The IBM Db2 SQL Reference for Cross-Platform Development Version 7 is now available

By Paul McWilliams posted Thu November 30, 2023 07:32 PM

  

By Paul McWilliams and Cynthia Suo.

We are pleased to announce that the IBM Db2 SQL Language Council (SLC) has just published Version 7 of the IBM SQL Refence for Cross-platform Development, and you can download the PDF-format manual today!

As we mentioned in a recent post, the SQL Reference for Cross-Platform Development includes SQL features that common to the Db2 family of products across the various platforms, and Version 7 is updated for new common features in the following Db2 product family releases: Db2 13 for z/OS, Db2 11.5 (for Linux, UNIX, and Windows), and Db2 for IBM i 7.5.

The major additions in Version 7 include the following features that are now supported by the Db2 family on all platforms:

  • Additional special register synonyms: CLIENT ACCTNG, CLIENT APPLNAME, CLIENT USERID, CLIENT WRKSTNNAME, CURRENT SERVER, CURRENT_TIMEZONE
  • SELECTIVITY clause
  • ISNULL and NOTNULL predicate synonyms
  • New built-in functions:
    • Numeric Scalar Functions: DECFLOAT_FORMAT
    • Miscellaneous Scalar Functions: HASH
  • Built-in function synonyms: COVAR_POP, ARRAY_TRIM, GREATEST, INSTR, LEAST, NVL, POW, RANDOM, STRLEFT, STRPOS, STRRIGHT, TO_CHAR, TO_CLOB, TO_DATE, TO_NUMBER, TO_TIMESTAMP
  • Query enhancement for SKIP LOCKED DATA
  • CREATE TABLE and ALTER TABLE support for RESTRICT ON DROP
  • CREATE PROCEDURE supports OR REPLACE
  • DECLARE CURSOR supports RETURN TO CLIENT
  • Column name length increased to 128 bytes

For more about the SQL Reference for Cross-Platform Development and links to a view of common features, and links to the platform-specific SQL Reference manuals, see SQL Reference for Cross-platform Development.

0 comments
22 views

Permalink

https://community.ibm.com/community/user/blogs/paul-mcwilliams1/2023/11/30/db2-sql-reference-cross-platform-development-v7