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.