Articles & Content

Archives

SQL Update - Bonnie's take on the new SQL in V8/9/10 - Part 2 - A06

Topic: DB2 for z/OS

Subtopic: 2012



This session not only covers the ins and outs of new SQL, it also covers odd uses for the new features and takes a look at how old problems are solved by new functionality. Each subject is explained in simple to understand terms. Topics: 1. Static Scroll Cursor "Built-in Optimistic Locking" 2. UPDATE WHERE CURRENT OF used with Unambiguouly read-only CURSORS (e.g.with an ORDER BY) 3. Forcing SORT avoidance 4. Realistic uses for scrollable CURSORs 5. Great Uses for FINAL_TABLEs 6. Programming tricks from DCLGENS to DIAGNOSTICS 7. ROWID tricks 8. Little known but useful features



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.