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 ...