SQL Tips for DB2 LUW

Serge Rielau continues to amaze the DB2 LUW community with his SQL skills! In this blog he is sharing interesting SQL solutions for DB2 LUW as well as hints on how to move Oracle applications to DB2.

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.

 

DB2 Tech Talk: DB2 pureScale + HADR for Always Available Transactions, DB2 10.5 SQL Tips for DB2 LUW Distinctly weak type rules with a constrained twist SQL Tips for DB2 LUW DB2 Tech Talk: Deep Dive on BLU Acceleration in DB2 10.5, Super Easy Analytics SQL Tips for DB2 LUW More family matters: Selected common SQL features for developers of portable DB2 applications SQL Tips for DB2 LUW DB2 Tech Talk: Introduction and Technical Tour of DB2 10.5 with BLU Acceleration on May 8th SQL Tips for DB2 LUW In the PIPE: Compiled SQL PL and PL/SQL Table Functions SQL Tips for DB2 LUW Full reverse: A REVERSE function that handles unicode SQL Tips for DB2 LUW Size matters: A handy routine to compute the defined row size of a table SQL Tips for DB2 LUW DB2 Tech Talk: Inside Row and Column Access Control for DB2 10 for LUW SQL Tips for DB2 LUW Fractions of time: A PostgreSQL compatible DATE_PART function SQL Tips for DB2 LUW DB2 Tech Talk: Deep Dive into the new PureData expert integrated systems! SQL Tips for DB2 LUW Migrating from TSQL: The DATEADD function SQL Tips for DB2 LUW