SQL Programming Language

RPG IV and SQL Developers

It is assumed that participants are proficient in both Basic SQL and a programming language. It is also assumed that the participants are at least somewhat familiar with the ACS tools for the database.

SQL PL – Programming Language

• Set Option Statement
• Declaring Variables and Constants
• Assignment Statement: SET
• Condition Statements: IF/CASE
• Loop Statements: LOOP / WHILE / REPEAT / FOR
• Static and Dynamic SQL
• Single Row Access
  • SELECT ... INTO / Values Into
• Cursor Handling
  • Serial and Scroll Cursors
  • Update through Cursors
• Error Handling
  • Continue/Exit/Undo Handler

ACS Integrated Debugger

Stored Procedures

• External and SQL Stored Procedures
  • Calling Stored Procedurs (incl. Argument list)
• Parameters
  • Parameter Styles
  • Optional Parameters (with Default Values)
• Returning and Consuming Result Sets

User Defined Functions

• External and SQL Scalar Functions
• External and SQL Table Functions

Trigger

• External and SQL-Trigger
• Trigger Event and Trigger Time
• Conditioned Triggers and Trigger on Field Level
• Instead Of Trigger