IBM Data Management Community Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems. Join / Log in
06 SQL codes.mp4
On the server however, within routines, triggers or anonymous blocks most SQL is fixed and will execute just the way the definer of the object has specified it. There are, however exceptions to this rule: Executing DDL statements such as CREATE TABLE or DROP INDEX While DB2 supports select DDL statements, generally DDL is not part of the SQL PL syntax Execution of highly variable SQL
See matching posts in thread - DB2 SQL Replication...I have a cli...
See matching posts in thread - SQL command identification/sour...
See matching posts in thread - SQL Time...QUERY: (OPTIMIZATION TI...
See matching posts in thread - sql question...I am struggling wit...
See matching posts in thread - SQL Editor
See matching posts in thread - SQL COALESCE() does not support...
Posted by: Serge Rielau 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