RPG Bootcamp Session 7: Static SQL - Patrick Behr

Only available as part of a package

Topics

Define SQL Data Manipulation Language (DML)
Define and Use DML Statements Select, Inset, Update and Delete
Define and Use EXEC-SQL
Using Host Variables in SQL statements
Define and Use Host Structures
Handle Null Values in Tables Use the SQL
Handle SQL Return Codes (SQLCODE and SQLSTATE)
Define and Use SQL Cursors
Use the SQL OPEN Statement
Use the SQL FETCH Statement
Use the SQL CLOSE Statement
Use the SQL UPDATE Statement
Use the SQL DELETE Statement
Use the SQL SET OPTION Statements (ALWCPYDTA, CLOSQCLCSR)
Create a SQLRPGLE Program
Exercise: Redo CRUD Application Using SQL (CSCSTP), Take Service Program and Redo with SQL-based Service Program

Patrick Behr

Patrick Behr has been working on IBM i and its predecessors for 20 years, with a focus on RPG and DB2. Patrick has worked for large retail companies like Costco and Starbucks, manufacturing companies, small businesses and the government.

Patrick lives with his wife in Southern California and enjoys the many outdoor activities that the area affords, including kayaking, rock climbing and surfing. He and his wife also volunteer for local animal rescues and have fostered more than 700 dogs so far.