Developing IBM i Applications Using SQL

Unit 1. SQL review

• Lab exercise: SQL review

Unit 2. Using embedded SQL

• Introducing embedded SQL
  • Lab exercise: Change CHAIN to SELECT

• Writing programs that use embedded SQL
• Error handling
  • Lab exercise: Changing native to SQL I/O

• Using a cursor for multiple row result set
  • Lab exercise: Using a cursor

• Using embedded SQL (continued)
• Dynamic embedded SQL
  • Lab exercise: Dynamic embedded SQL

Unit 3. An overview of stored procedures

• Introducing stored procedures
• External stored procedures
  • Lab exercise: Create a stored procedure

• SQL stored procedures