Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at:   http://www.verhoef-training.com

103 Hillside Ave., PO Box 1515
West Caldwell, NJ 07006
Main Office:  800.631.0410
Sales Office:  800.533.3893

SQL – Using Embedded SQL in RPG IV

Course:   RPGSQL
Duration:   2 Days
Level:   II
On our website at:   http://www.verhoef-training.com/courses/RPGSQL.html
 
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.

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:

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.