System i (AS/400, iSeries, i5) Power RPG with SQL

Course Details:

Course Outline:

This course is designed for application development staff who need to view, create or modify data in a more flexible way than that afforded by standard RPG operation codes and logic.

Pre-requisites:

Delegates should have attended the Accessing DB2 with SQL (ISSQI) and RPGIV Programming (ISR4P) or RPG/400 Programming (ISRPP) courses prior to attending this course or have the equivalent hands on experience.

Course content:

• Data definition language
  • Create Database
  • Create Table
  • Referential Constraints
  • Trigger programs
  • Comment On/Label On
  • Drop/Views
  • Data Modelling and indexes for the data model
  • Using and controlling indexes
  • Creating/Dropping indexes
  • Indexes on non-key fields
  • Indexes for performance
  • General performance consideration
• Embedded SQL introduction
• Pre-compiling and running programs
• Syntax rules for using SQL in RPG
• Using host variables
• Using SELECT in RPG
• SQL return codes
• SQL commands for file maintenance
• Whenever statement
• Accessing rows from the results table
• Multiple record retrieval
• Updating/Deleting rows
• Dynamic SQL
• Execute immediate
• Prepare and execute
• Prepare a Select statement and Fetch results
• Open Using
• Variable sequencing

Follow on Courses:

There are no specific follow on courses to this course.

Schedule: