Over the years DB2's SQL Procedure Langiage (SQL PL) has taken on a more and more prominent role and those who know how to use it properly can do some amazing things. The next couple of posts are dedicated to SQL PL and to giving some advice on the do's and don'ts. First, in part one, let's start with a history brief lesson to get some perspective: DB2 V 2.1 for CS Supports for inline SQL PL Triggers . SQL PL means consists of exactly one construct: BEGIN ATOMIC .... END. Inside the compound you can do SIGNAL, INSERT, UPDATE, DELETE, VALUES and...
[More]
Tags: 
function
compile
procedure
sql
pl
trigger
psm
inline