SQL – Using Embedded SQL in RPG IV
Duration: 2 Days
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?
Using host variables
Using a SELECT statement
Using a Cursor
Identifying and handling errors
The power of INSERT, UPDATE and DELETE
When to use dynamic SQL
Using PREPARE and EXECUTE
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.
Before taking this course, a student should:
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.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]