Canada's Leader in Professional Development

855-581-7246 Call us: 1-855-581-7246

Developing IBM i Applications using SQL

Currently no upcoming Class Dates


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.

This course provides lectures and hands on labs in a face-to-face classroom setting. The course is also offered in a live virtual classroom environment (ILO -Instructor Led Online) with hands-on labs: Developing IBM I applications using SQL - ILO (OV380).


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


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


You should have taken:

  • Accessing the IBM i Database Using SQL (OL370) (OV370)
  • IBM i Application Programming Facilities Workshop (OL490)(OV490)
  • Accessing the DB2 UDB for iSeries Database Using SQL (OL370)
  • System i Application Programming Facilities Workshop (OL490)

You should be able to:

  • Use a Windows-based PC
  • Navigate IBM i menus and use IBM i commands
  • Use SQL Data Definition Language (DDL) to describe tables and views
  • Use the Program Development Manager/Source Entry Utility or the RSE LPEX Editor to code programs
  • Use SQL SELECT statements to extract data from tables and views
  • Use SQL UPDATE, INSERT, ALTER and DELETE statements to modify SQL tables
  • Code SQL queries that include column and scalar functions
  • Code SQL queries that include inner and outer joins
  • Use the ILE Source Debugger
  • Code RPG programs on the IBM i


2 days


Unit 1. SQL review

  • Lab exercise: SQL review

Unit 2. Using embedded SQL

  • 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

Unit 3. An overview of stored procedures

  • Introducing stored procedures
  • External stored procedures
    • Lab exercise: Create a stored procedure
  • SQL stored procedures

Click here to reach us by Email Contact Us
About | Terms of Use | Privacy Visit our Facebook page   Visit ot Linkedin page   View our Tweets