SQL – Using Embedded SQL in RPG IV

Course:  RPGSQL
Duration:  2 Days
Level:  II
Course Summary

This course teachs the basics of using embedded SQL in RPG IV programs and how to maximize the use of embedded SQL within applications.

« Hide The Details
Topics Covered In This Course

A recap on Relational Database

Overview and Terminology

SQL and the i

Why use embedded SQL?

Basic Syntax

Using host variables

Using a SELECT statement

Using a Cursor

Identifying and handling errors

The power of INSERT, UPDATE and DELETE

Compile options

When to use dynamic SQL

Using PREPARE and EXECUTE

Performance tips

What You Can Expect

On completion of the course, participants should be able to use embedded SQL within RPG IV programs, know when to best use embedded SQL and how to look at performace considerations.

Who Should Take This Course

RPG Programmers who wish to enhance their programming skills by using embedded SQL.

Recommended Prerequisites

Before taking this course, a student should:

  • Have at least six months experience of programming in RPG IV
  • A knowledge of SQLs Data Manipulation Language (DML) available throughSQL - Introduction or equivalent experience
« Hide The Details
Related Courses
Code Course Title Duration Level
ISQL
SQL for iSeries 400 Programmers
3 Days
I
Details
RPG3TO4
RPG III (RPG/400) to RPG IV and ILE
4 Days
II
Details
RPG4
RPG IV Programming
5 Days
II
Details
RPGWEB
RPG Meets The Web
1 Day
II
Details
RPGILE
RPG ILE Programming Advanced Topics
4 Days
III
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com