Using DDL to define your files provides a wealth of new features, but just which features should you embrace? Some of that depends on the tools you use, and this article explains a couple of pitfalls.
Written by Joe Pluta
The ongoing SQL vs. native I/O debate really consists of two different debates: how to define your data and how to access it. Access is either via native I/O or SQL, but that's not the topic today. Today, I'm focused on the data definition debate, either the older Data Definition Specifications (DDS) or the more modern SQL-based Data Definition Language (DDL). I firmly believe this dispute has been decided in favor of DDL, but DDL is not perfect. Some potential pitfalls exist, and this article will address one of the more onerous problems.
SQL CASE expressions are powerful. Understand their syntax and where they can be used.
Written by Sam Lennon
Did you know that the SQL CASE construct can be used in SQL SELECT and UPDATE statements and in WHERE, GROUP BY, and ORDER BY clauses? This tip explains SQL CASE through examples that you can run and experiment with. It also gives an overview of SQL CASE syntax, though it does not attempt to rewrite the IBM DB2 for i SQL Reference manual.