Verhoef Training Europe.

11B Kingsmead Square, Bath, BA1 2AB, UK
Phone:+44 (0)1753 852 233 Fax: +44 (0)1753 840 190



Embedded SQL and Stored Procedures




AUDIENCE:   iSeries and i5 programmers who wish to take advantage of SQL in their RPG programs.

PREREQUISITES:   RPG programmer knowledge and basic knowledge of SQL.

DURATION:   2 days. Hands on. This course is available on site only.

OBJECTIVES:   After attending you should be able to:

  • Embed SQL statements in your RPG code
  • Understand when it is appropriate to use embedded SQL
  • Create iSeries/i5 stored procedures
  • Understand the use and advantages of stored procedures
  • Understand the use of CLI on the iSeries/i5

COURSE CONTENT:  

  • Static SQL
  • Dynamic SQL
  • Coding stored procedures
  • Call level interface

© 2007 Verhoef Training