Duration

2 days

Overview

This course is designed primarily to teach experienced IBM i RPG IV programmers how to use embedded SQL in IBM i RPG IV programs.

As a secondary purpose, you also learn to create and use simple SQL stored procedures.

Learning Journeys or Training Paths that reference this course:

Application Developer using SQL

Audience

This intermediate course is for experienced IBM i RPG IV programmers who want to learn how to use SQL as a means to perform Input/Output (I/O) to access DB2 for i in their applications.

Prerequisites

You should complete the following courses (or have the equivalent skills taught in these courses):

Accessing the IBM i Database using SQL (OL37G)
Developing IBM i Applications Using SQL (OL38G)

Key topics

Lab exercise: SQL review
Introducing embedded SQL
Lab exercise: Change CHAIN to SELECT
Writing programs that use embedded SQL
Error handling
Lab exercise: Changing native to SQL I/O
Using a cursor for multiple row result set
Lab exercise: Using a cursor
Using embedded SQL (continued)
Dynamic embedded SQL
Lab exercise: Dynamic embedded SQL
Introducing stored procedures
External stored procedures
Lab exercise: Create a stored procedure
SQL stored procedures

Objectives

Code embedded SQL statements in RPG IV programs
Create and use of stored procedures

Follow-on courses

Control Language Programming workshop for IBM i (OL20G)

This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.