Session Two: Darn… Cursed Again! – Using SQL & Cursors in your Programs

This session demonstrates the use of SQL in your programs. After a short discussion of the differences between Dynamic and Static SQL in your programs; we demonstrate the important concepts in creating a robust SQL program. Topics include host variables, data-structures, error trapping and using tables with SQL.


  • Internalize the benefits of using SQL in your programs.
  • Correct use of SQL and CURSORS in your RPG Programs.
  • Understand error handling in SQL subprocedures and service programs.