FASUG Application Development Day 2006

Track C Session 3

Embedding SQL in an HLL (RPG) Program
SKIP MARCHESANI


Embedding SQL in an HLL (RPG) Program

This session will introduce you to the programming required to embed SQL in higher level language code to replace the native database I/O. We will start with a review of software requirements, the SQL precompiler, and the syntax of embedded statements. Then we will see how to use SQL Cursor operations to select and process groups of related records using FETCH, UPDATE and DELETE. We will explore error handling, dynamic SQL, and how to edit and compile a program using embedded SQL, and conclude with some tips and techniques to ensure good performance. A basic understanding of SQL is required.


Web Page: Ashway Consulting, LLC.