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.
SKIP MARCHESANI
Embedding SQL in an HLL (RPG) Program
Web Page: Ashway Consulting, LLC.