iSeries Embedded SQL Class

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. This course is designed for RPG programmers who have some understanding of SQL.

Class Details:

• Prerequisites: iSeries SQL Interactive or equivalent. Students should be comfortable with the editor (SEU), and have some experience with SQL.
• Duration: One Day
• Cost: $450/day
• Associated Roadmap
• Downloadable flyer

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