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 create reports in Toad for Oracle with multiple non-related datasets
Toad's Report's Manager has been around for a while, and it's great at making pretty reports of either a single dataset, a simple master-detail dataset, or complex master-detail datasets with multiple...
Using Zeppelin to Access MySQL
If you want to access MySQL Cloud Service using Zeppelin of Oracle Big Data Cloud Service Compute Edition (BDCSCE), you can use Spark DataFrames or Zeppelin interpreters. In this blog post, I’ll show ...
Criteria for Selecting Best SQL
This tip covers how to consider the disk I/O when selecting the best SQL alternative. When selecting the best performing SQL statement for your application, how should disk I/O be weighed in compariso...
