ComCon
Contact
    HOME  |  ABOUT US  |  COMMUNITY  |  DOWNLOAD
 
March 17-19, 2015 in Dallas          


    Services
    Courses
    Workshops
    Sessions
    Articles
    Books

SQL - Using Embedded SQL in RPG IV

Duration

2 days

What the Course Covers

This course teachs the basics of using embedded SQL in RPG IV programs and how to maximize the use of embedded SQL within applications. A knowledge

How Can You Apply the Skills You Will Learn?

On completion of the course, participants should be able to use embedded SQL within RPG IV programs, know when to best use embedded SQL and how to look at performace considerations.

Who Should Attend

RPG Programmers who wish to enhance their programming skills by using embedded SQL.

Prerequisites

Before taking this course, a student should:
  • Have at least six months experience of programming in RPG IV
  • A knowledge of SQLs Data Manipulation Language (DML) available through SQL - Introduction or equivalent experience

Agenda

The following topics will be covered
  • A recap on Relational Database
  • Overview and Terminology
  • SQL and the i
  • Why use embedded SQL?
  • Basic Syntax
  • Using host variables
  • Using a SELECT statement
  • Using a Cursor
  • Identifying and handling errors
  • The power of INSERT, UPDATE and DELETE
  • Compile options
  • When to use dynamic SQL
  • Using PREPARE and EXECUTE
  • Performance tips
Home | About Us | System i Community | Contact
ComCon © 1994 - 2017. This site is hosted on an  i