name :
OL38G
title :
Developing IBM i Applications Using SQL
category :
Power Systems
vendor :
IBM
classroomDeliveryMethod :
Classroom IBM
descriptions :
description :
OverviewThis 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.AudienceThis 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.PrerequisitesYou 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)
Objective
  • Code embedded SQL statements in RPG IV programs
  • Create and use of stored procedures
Course OutlineUnit 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
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.]
abstract :
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.
prerequisits :
objective :
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. 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)
Objective
  • Code embedded SQL statements in RPG IV programs
  • Create and use of stored procedures
topic :
Course OutlineUnit 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
startDate :
2018-04-22T08:51:00Z
endDate :
2019-01-30T00:00:00Z
lastModified :
2018-04-22T08:00:39Z
created :
2014-05-03T19:09:53Z
duration :
2
durationUnit :
DAYS
listPrice :
currency :

Enquire about this course: