Presenter: Paul Tuohy
Topic: Using Embedded SQL in RPG
Many RPG programmers have used interactive SQL as a tool to quickly browse data or to create test data scenarios, but have stopped short of embedding it into their RPG programs. But using SQL in RPG programs brings a whole new set of possibilities to database processing.
This session looks at:
- Why use embedded SQL?
- Basic Syntax
- Using host variables
- Using a SELECT statement
- Using a Cursor
- Identifying and handling errors
- The power of INSERT, UPDATE and DELETE
- Compile options
- When to use dynamic SQL
- Using PREPARE and EXECUTE
- Performance tip
|