Embedded SQL in RPG

RPG IV and SQL Developers

It is assumed that the participants have mastered both RPGIV (Free Format) and SQL basics. It is recommended that participants first take the course SQL Queries for professionals so that they learn what is possible in SQL and can then use SQL correctly.

Overview

• Terminology
• Pre-Requisites
• (Pre-)Compile

Embedding SQL in RPG

SQL without Data Access

Using Variables in SQL

• Host Variables
• Indicator Variables

Error Handling

• Based on the SQLCA (Communications Area)
• GET DIAGNOSTICS

Data Access without Cursor

• Static SQL
• Dynamic SQL

Cursor Types

• Serial Cursor
• Scroll Cursor

Static SQL with Cursor

• Consuming the Cursor Data
• Updating/Deleting rows with a Cursor

Dynamic SQL with Cursor

• Fixed Select List
• Varying Select List
  • SQLDA (Descriptor Area)

Consuming Result Sets returned by Stored Procedures

Reading and Writing IFS Documents

Performance

• SQL Analysis Feedback Tools in ACS
• Index Advisor, Index Condenser, Index Evaluator