Duration
2 days
Delivery Type
- Classroom with hands-on
Prerequisites
Students must have attended these courses:
- IBM iSeries System Operation & Management
- RPG ILE Programming (Beginner)
DAY 1
SQL in iSeries
- Introduction to Structured Query Language
- SQL Commands in iSeires to:
- Create Table
- Alter Table
- Drop Table
- Selection Statement
- Insert record
- Update record
- Delete record
- Join Table
- iSeries System Terms & SQL Terms
DAY 2
Embedded SQL in ILE RPG. (SQLRPGLE)
Introduction
- Host Variables
- SQL Built-in Functions
- Using embedded SQL in:
- Record selection
- Create database file
- Update database file
- Screen manipulation
- Reporting
Programme scope, delivery arrangements and suitability are confirmed during enquiry.