IBM Support

PH64377: NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • NEW FUNCTION
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Db2 13 for z/OS users of the             *
    *                 CURRENT APPLICATION COMPATIBILITY special    *
    *                 register and the USING APPLICATION           *
    *                 COMPATIBILITY clause of various              *
    *                 ALTER statements.                            *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR introduces support for the    *
    *                      abbreviated spelling 'APPLCOMPAT'       *
    *                      where 'APPLICATION COMPATIBILITY' is    *
    *                      used in various SQL statement contexts  *
    *                      to simplify the coding of these         *
    *                      statements.                             *
    ****************************************************************
    This APAR introduces support for the abbreviated spelling
    'APPLCOMPAT' where 'APPLICATION COMPATIBILITY' is used in
    various SQL statement contexts to simplify the coding of these
    statements.
    

Problem conclusion

Temporary fix

Comments

  • This APAR adds support for the abbreviated spelling
    'APPLCOMPAT' where 'APPLICATION COMPATIBILITY'
    is used in the following SQL statement contexts:
    * Any reference to the CURRENT APPLICATION COMPATIBILITY
      special register.
    * In the USING APPLICATION COMPATIBILITY clauses
       of the following SQL statements:
       - ALTER FUNCTION
       - ALTER INDEX
       - ALTER MASK
       - ALTER PERMISSION
       - ALTER PROCEDURE
       - ALTER TRIGGER
       - ALTER VIEW
    
    The abbreviation is supported when the PTF is applied
    in Db2 13 at any function level and application compatibility
    level.
    
    The online product documentation for Db2 13 is updated for
    new function in this APAR. To find the changes and related
    information, search on "PH643777" or the following keywords:
     - CURRENT APPLICATION COMPATIBILITY special register
     - SET CURRENT APPLICATION COMPATIBILITY
     - USING APPLICATION COMPATIBILITY
     - APPLCOMPAT
    

APAR Information

  • APAR number

    PH64377

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    D10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2024-12-02

  • Closed date

    2025-01-21

  • Last modified date

    2025-02-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI99701

Modules/Macros

  • DSNHAPLY DSNHBNFE DSNHPTAB DSNHSM2V DSNHSM6C DSNHSYMH DSNLZOSR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RD10 PSY UI99701

       UP25/01/29 P F501  

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 February 2025