RPG Bootcamp Session 10: Additional SQL Techniques - Ray Everhart

Topics

• Dynamic SQL vs Static SQL Use Sases
• Use the SQL PREPARE Statement
• Use the SQL EXECUTE Statement
• Using Prepare with Cursors
• Reserved Variable Names
• Exercise: Convert Report Application to a Subfile SQL – Dynamically Control How Sorted Based on Parameter (CSCSTP)
• Commitment Control – Why It Is Important
  • Commitment Scope
  • Rollback and Commit Statements
  • Set options statement for defining commit options
• Exercise: Order Entry Application with Commitment Control (CSCSTP, CSINVP, CSORDP, CSORDPRP)