Close

Let’s Meet Mr. Advance Trigger!

(FF)

Stream: Db2
Time: 16:45 - 17:45

Presentation

Triggers move the business rule application logic into the database, which results in faster application development and easier maintenance. The business rule is no longer repeated in several applications, and the rule is centralized to the trigger. Db2 12 for z/OS with new function activated, enhances support for triggers, introducing new “advanced triggers” and continuing to support simple triggers as supported by previous releases. These simple triggers that could have been defined in earlier releases are now referred to as “basic triggers”.
 
Basic triggers support a limited set of SQL statements which takes a longer time to develop and deploy applications that use capability not currently supported, as the trigger body needs to call a stored procedure to provide additional capability. As a result, this increases the cost of using DB2 for z/OS, degrades the application performance for CPU and elapsed time and increases the maintenance cost to manage more objects. 
 
Restrictions of basic trigger has been overcomed by Advance Trigger which provides support for complex and logical SQL/PLs within the body of trigger. It also provides enhancements like - ability to define and maintain multiple “Versions”, allowing users with debugging capabilities and to better align itself with the DB2 family and SQL standards. 
 
 
We will also cover in this presentation the following: 
• Introduction to Triggers
• Types of Triggers (i.e., Basic and Advance Trigger) and difference between them.
• Why one needs to know about Advance Triggers when Stored procedures exists?
• Syntax of Create and Alter Triggers, along with its important parameters
• Limitations and Considerations while using Advance Triggers
• Authorizations and Privileges required for Advance Triggers
• Examples of complex SQL queries which are now supported in Advance Triggers

Attachments

FF Attachments

Speakers

  • Jaspreet Kaur Dhoad at BMC Software Ltd

    • Role: Senior Product Developer, BMC Software. Work Experience : Jaspreet holds 17+ years of IT experience, with a strong background as an Application Programmer specializing in Mainframes and DB2. Throughout her career, she has successfully developed applications in the Insurance and Banking domains, showcasing her proficiency in these sectors. Work Profile in BMC: Jaspreet is with BMC Software since 2020 and has been an integral part of DB2 Admin Product team specifically working on Change Manager Product. She consistently seeks opportunities to enhance and advance the mainframe products at BMC Software.


    Email: jaspreetkaur_dhoad@bmc.com

  • Pradip Wagh at BMC Software Ltd

    • Role: Senior Product Developer, BMC Software. Work Experience: Pradip holds 14+ years of IT experience, with a strong background as an Application Programmer. In addition to his technical expertise, he has also excelled in roles such as Business and System Analyst in Mainframes and DB2. Throughout his career, he has worked on numerous projects and has proven expertise in developing applications in the Insurance and Banking domains. Work Profile in BMC: Pradip is with BMC Software since 2021 and has been an integral part of DB2 Admin Product team specifically working on DB2 Change Manager Product.


    Email: pradip_wagh@bmc.com

    Feedback

    Click here to give some Feedback so we can make it even better next year!