Chapter 3. SQL Standards and Guidelines
Every IT shop that has applications involving DB2 should have a set of SQL standards and guidelines for its developers to follow. This chapter is a start for developers and project managers to use as part of their development. Once you have a set of standards and guidelines, be sure to enforce them. Every program should have code walkthroughs to ensure that standards and guidelines are being followed.
The standards and guidelines that follow serve multiple purposes:
• Relate to performance
• Alleviate abends and/or production incident reporting
• Reduce I/O and CPU costs
• Increase productivity
• Improve client satisfaction
• Improve readability and understandability
The standards and guidelines that follow ...
Get DB2 SQL Tuning Tips for z/OS Developers 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.
