Using Embedded SQL

Presenter: Paul Tuohy

This session will show you how to use SQL in RPG programs. Each new releae of the operating system incorporates improvements to the use of SQL and, as applications are modernized, the use of SQL in RPG programs plays an ever increasing role.
You will learn about;

• Syntax
• Host Variables
• Host Structures
• Using SELECT, UPDATE, INSERT and DELETE.
• Declaring, opening and closing a CURSOR.
• FETCHing rows.
• SQL Error Handling
• Compilation Considerations