Topic: DB2 for z/OS
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.