Chapter 2. Data Manipulation Guidelines

In This Chapter

• A Bag of Tricks

• SQL Access Guidelines

• Complex SQL Guidelines

• Common Table Expressions and Recursion

• Working with Nulls

• Date and Time Guidelines

• Data Modification Guidelines

In Chapter 1, “The Magic Words,” you learned the basics of SQL, but you can gain a deeper body of knowledge on the proper way to code SQL statements. Any particular method of coding an SQL statement is not wrong, per se, as long as it returns the correct results. But, often, you can find a better way. By better, I mean

• SQL that understands and interacts appropriately with its environment

• SQL that executes more efficiently and therefore enhances performance

• SQL that is clearly documented and therefore ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial