4levels teams with the top technology providers to enhance your operations   |   Domains & Hosting   |  Get Support   | My 4levels
GET IN TOUCH
+27 (0)11 848 6229

IBM

4levels-IT-Default-Header

Developing IBM i Applications Using SQL


Course Description


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.  

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

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

Objectives

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

Course Duration

1 Day
  • Brands we have partnered with to add value to your business


    We are committed to helping our clients reach their business goals

    4levels’ preferred access to the latest technologies, premier technical support and advanced training helps provide you with specialist and customized solutions that help you achieve your business goals.

4levels Solutions sign up form


Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur excepteur sint occaecat cupidatat non

4levels Solutionslogin form