SQL PL Examples
From SQL PL Guide for DB2
SQL PL Examples
- Procedures
- Runstats
- Select statement in dynamic SQL by using PREPARE, OPEN, FETCH and CLOSE
- Checking how much reorgs are recommended on a schema
- Sleep Procedure
- ...more examples are coming soon...
- Triggers (by using Inline SQL PL)
- Simple Before Trigger by using SIGNAL and SQLSTATE
- User Defined Functions (by using Inline SQL PL)
- ...coming soon...