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
SQL Pattern Matching in Toad Data Point
SQL allows for the selectivity of character data with a specific pattern and NOT in a specific pattern. Either way, pattern matching syntax will always be useful when sifting through your extensive da...
ABC’s of Global Data Services – 12C
Prior to Oracle 12c we are familiar with the local data services which offers the connectivity to the desired database and managed workload across instances and route the connection to the standby dat...
KPIs For DBAs to Show Their CIOs
It is perfectly valid for a DBA (or their manager) to assign KPIs to the servers and databases they administer. KPIs are unique for every shop, and for every role. The post appeared first on https://...
