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.