|
Prerequisites: iSeries SQL Interactive or equivalent. Students should be comfortable with the
editor (SEU), and have some experience with SQL.
Audience: This course is designed for RPG programmers who have some understanding of SQL.
Description: A detailed review of the techniques used to embed SQL instructions inside RPG programs.
SQL Embedded combines the flexibility of SQL with the sophistication of RPG to create a powerful hybrid program.
This class demonstrates embedding techniques using hands on labs, and also reviews more advanced concepts.
Course Content:
SQL Basics
- Why embed SQL?
- How to embed SQL in a RPG program
- The syntax used when coding SQL
- The SQL pre-compiler
- New fields provided
SQL Statements
- Embedding the SQL SELECT statement
- Using the PREPARE statement
- Using the DECLARE statement
- SQL cursors and handles
- Using the OPEN, FETCH, and CLOSE statements
Advanced Topics
- Error Handling
- Complex SQLs
- Advanced Cursor options
- Commitment Control
- Using Descriptors
- NULL Values
Duration: One Day
Click here to register on-line or review
our current Course Schedule.
Download
class flier in PDF format.
|