DEVELOPING ISERIES APPLICATION USING SQL (OL38)

Format

Classroom

Duration

3.0 Day(s)

Description

This course is designed to teach experienced AS/400 RPG programmers how to:
* use embedded SQL in AS/400 RPG IV programs
* explain the use of SQL Stored Procedures
* explain the use of the Call Level Interface

Audience

This course is designed for experienced AS/400 RPG programmers who want to learn how to use SQL as an alternate means to access the AS/400 database in their applications.

Prerequisites

Before attending this class, the student should be able to:
* use SQL Data Definition Language (DDL) to describe tables and views
* use SQL UPDATE, INSERT, ALTER and DELETE statements to modify SQL tables
* use the SQL SELECT statement to extract data from tables and views
* code SQL queries that include column and scalar functions
* code SQL queries that include inner and outer joins
* navigate AS/400 menus and use AS/400 commands
* use PDM and SEU to code programs
* use the ILE Source Debugger
* code RPG programs on the AS/400
Experience coding applications in the RPG IV language is strongly recommended but RPG III background is acceptable. RPG IV language features will not be taught. If you have no knowledge of RPG IV, you may get lower value from this class that an experienced RPG IV programmer would.
These skills can be obtained by attending the following courses:
* OL45V1/S6145 - DB2 UDB for AS/400 Concepts and Facilities
* OL49V4/S6149 - AS/400 Programming Facilities Workshop
* OL37V1/S6137 - Using SQL to Access the AS/400 Database
* OE85V3/S6126 - Moving from RPG/400 to RPG IV
OR
* OL86V2/S6109 - AS/400 RPG IV Programming Workshop

Objectives

After attending this class, the student should be able to:
* code embedded SQL statements in RPG IV programs
* explain the use of Stored Procedures
* explain how the Call Level Interface can be used

Contents

The course units are:
1. SQL Review
2. Using Embedded SQL
3. An Overview of Stored Procedures
4. Introducing the SQL Call Level Interface