Part I. SQL Techniques, Tips, and Tricks
Part I of this book offers up a bag of SQL techniques and tricks that will help you squeeze every bit of performance and effectiveness out of the SQL code in your DB2® applications.
Chapter 1, “The Magic Words,” introduces SQL and provides tools for the SQL practitioner. Chapter 2, “Data Manipulation Guidelines,” provides a collection of simple suggestions to speed data access and modification; it suggests tips for both simple and complex SQL statements.
Chapters 3 and 4 cover DB2 functions and how they can be used to convert data from one state to another. Chapter 3, “Using DB2 Functions,” covers the built-in functions, and Chapter 4, “Using DB2 User-Defined Functions and Data Types,” discusses how to ...
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.