> > > OL38G Detailed outline

Developing IBM i Applications Using SQL (OL38G)

Course Description Schedule Course Outline

Detailed Course Outline

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