Using SQL in a HLL (RPG, COBOL) Program
Skip Marchesani
Using SQL in a HLL (RPG, COBOL) Program
This session is designed to provide an introduction to the basic programming requirements for embedding or using SQL in a High Level Language program to do all database file I/O in place of native I/O. First, you will review software requirements, how the SQL precompiler works, and the syntax for embedding SQL statements in an RPG or COBOL program. Then you will see how SQL Cursor operations can be issued to select and process groups of related records, using the SQL statements like DECLARE CURSOR, FETCH, UPDATEand/or DELETE. Next you will explore error detection and handling with SQL, dynamic SQL, and how you edit and compile a program that uses embedded SQL.
Skip Marchesani retired from IBM after 25 years and is now a consultant with Custom Systems Corp, an IBM Business partner. Recognized as an industry expert on DB2/400 and author of the book 'DB2/400': The New AS/400 Database', he specializes in providing customized education for any area of the AS/400, does database design and design reviews, and general AS/400 consulting for interested clients. He has been a speaker for user groups, technical conferences, and AS/400 audiences around the world. Skip is an award winning COMMON speaker and has received their Distinguished Service Award.