RPG Bootcamp Session 10: Additional SQL Techniques - Ray Everhart


Back to Package

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)

Ray Everhart

Product Manager, X-Analysis, Fresche Solutions

Product Manager, X-Analysis, Fresche Solutions

Key:

Complete
Failed
Available
Locked
Video
Open to view video.
Open to view video. RPG Bootcamp Video 10