Interested in bringing a class to you? One-company training
Overview
| Course code | OL38GB | Delivery type | Classroom |
|---|---|---|---|
| Duration | 2.0 days | Course type | Public or Private on-site |
| List price |
GBP £800 plus VAT
GBP £920 incl. VAT |
||
Cross-training for experienced RPG programmers learn to use embedded SQL as an alternative to traditional file processing.
View this course in other countries
Roadmaps that reference this course are:
Abstract
Each student will have a dedicated workstation to complete the numerous practical exercises. Sample solutions will also be provided.
Pre-requisites
Before attending this course, students should be able to:
- Write SQL DDL statements for maintaining the iSeries DB2 UDB database
- Write SQL DML statements for the retrieval and manipulation of information stored in the iSeries DB2 UDB database.
These skils can developed by attending the following courses:
OL49I - iSeries Technical Introduction
OL37 - Accessing the iSeries Database Using SQL
Objective
After attending this course, students should be able to:
- Code embedded SQL statements (static and dynamic) in RPG programs to perform database I/O operations
- Explain the use of SQL Stored Procedures
Key topics
The course includes the follwoing Topics:
- Review of the SQL language
- Coding Static SQL statements in RPG IV programs
- Coding Dynamic SQL statements in RPG IV programs
- SQL Stored Procedures
Remarks
For more detailed information about this course see http://www-5.ibm.com/services/learning/uk/OL382DTS.pdf
