Verhoef Training

11 Kingsmead Square, Bath, BA1 2AB.
Tel: 01225 339705 Fax: 01225 339671




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, Ltd.