RPG Bootcamp Session 7: Static SQL - Patrick Behr

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.

Key:

Complete
Failed
Available
Locked
Video
Open to view video.
Open to view video. RPG Bootcamp Session 7