SQL - Using Embedded SQL in RPG IV
Duration
2 daysWhat the Course Covers
This course teachs the basics of using embedded SQL in RPG IV programs and how to maximize the use of embedded SQL within applications. A knowledgeHow Can You Apply the Skills You Will Learn?
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 Attend
RPG Programmers who wish to enhance their programming skills by using embedded SQL.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 through SQL - Introduction or equivalent experience
Agenda
The following topics will be covered- 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