IBM TechXchange UKI Db2 for z/OS User Group

IBM TechXchange UKI Db2 for z/OS User Group

 View Only

Blog Post - APPLCOMPAT and Advanced Triggers

  • 1.  Blog Post - APPLCOMPAT and Advanced Triggers

    Posted Wed August 28, 2019 04:00 AM
    Now that more installations in the UK are getting further into Db2 12, here is a useful blog on how APPLCOMPAT and function levels could make life difficult! and how to resolve the problem.

    Are you a member of World of DB2? Join today and receive latest updates from IBM!
    World of Db2 remove preview
    Are you a member of World of DB2? Join today and receive latest updates from IBM!
    If you think you know all about APPLCOMPAT, then please read this! Advanced triggers introduced in V12 allow SQL PL statements and this opens "SQL only applications" to triggers. There is reduced need to call a stored procedure, if more complex code is needed inside a trigger.
    View this on World of Db2 >


    ------------------------------
    Karen Wilkins
    Client Technical Professional
    IBM UK Ltd
    Bristol
    ------------------------------