Start_With_RPLG

What will you learn?

Description

In this workshop you learn how to use the different types of SQL functions from within an RPGLE program.

 Based on the example programs provided in the course materials, calling the various types of SQL functions from within an RPGLE program is explained, as well as exception handling. You will also learn how to find help as well as some tips and tricks for performance, maintenance and readability.

Learning objectives

  • Learn to execute SQL instructions from within an RPGLE program to retrieve or update data or to execute SQL functions
  • Learn best practices for performance, maintenance and readability

This course covers the following topics

  • Introduction to SQLRPGLE : What can you do with SQL in RPGLE
  • Example programs explaining the different possibilities
  • Set options
  • Retrieve 1 row using select into
  • Retrieve 1 value using values into or set
  • Update, insert, delete
  • Use of sqlcode and sqlstate
  • Retrieve multiple rows
  • Use of sql cursor
  • Fetch one by one or multiple rows at once
  • Static sql with use of host variables
  • Dynamic sql with use of parameter markers
  • Handling of null values
  • Get diagnostics
  • Retrieve error information
  • Retrieve row count
  • Tips and tricks for performance, maintenance and readability
  • Finding help

Prerequisites

  • Some programming experience in RPGLE
  • Some experience in using Rational Developer for i
  • Recent version of Access Client Solutions installed on your PC
  • Recent version of Rational Developer for i installed on your PC
  • Connection available to your IBM i environment