Articles & Content

Archives

A08 - SQL Programming: 30 tips in 60 minutes!

Topic: DB2 for z/OS

Subtopic: 2015



This session will cover in rapid fire succession a large number of pitfalls I have seen in code reviews over the last 2 decades. Numerous topics will be covered including Identity columns/Sequence objects, case statements, outer joins, subselects, use of Distinct, trouble with nulls, outer joins, indexing, programming logic to name just a few. We will also cover why it is important to ask the right question in SQL.
The session will provide food for thought and serve as a template for your own code reviews.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.