In this, the fourth of a set of four entries covering SQL enhancements introduced with Db2 12 for z/OS, I will describe new trigger capabilities delivered by way of what are called “advanced triggers” (the kind of trigger that you could define prior to Db2 12 — and which you can still create in a Db2 12 system — is now referred to as a “basic trigger”). Before getting to the details of advanced trigger functionality, I want to emphasize that there are considerably more than …read more
Related Articles
How to analyze code with Toad for Oracle Xpert Edition
This video shows how to analyze code with Toad for Oracle Xpert Edition....
When to Use Server-Side Logic
The use of server-side logic, particularly stored procedures, has been a highly contentious topic among database professionals for decades. The question has always been what amount of logic should be ...
SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files...
Few days back I wrote blog to help my blog reader and this is follow up on the same post How to Add Date to Database Backup Filename? – Interview Question of the Week #109. In this blog post we will s...
