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.
1. Internalize the benefits of using SQL in your programs.
2. Correct use of SQL and CURSORS in your RPG Programs
3. Understand error handling in SQL subprocedures and service programs