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