ZL1_OL38

Ladda ner som PDF

Developing IBM i Applications Using SQL

This course is designed primarily to teach experienced IBM i RPG IV programmers how to use embedded SQL in IBM i RPG IV programs. As a secondary purpose, you also learn to create and use simple SQL stored procedures.

Audience

This intermediate course is for experienced IBM i RPG IV programmers who want to learn how to use SQL as a means to perform Input/Output (I/O) to access DB2 for i in their applications.

Prior knowledge

You should complete the following courses (or have the equivalent skills taught in these courses):

  • Accessing the IBM i Database using SQL (OL37G)
  • Developing IBM i Applications Using SQL (OL38G)

Course Objectives

  • Code embedded SQL statements in RPG IV programs
  • Create and use of stored procedures

Content

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

Course Objectives

  • Code embedded SQL statements in RPG IV programs
  • Create and use of stored procedures

Content

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

Utbildningen levereras i samarbete med

Kursfakta

Kurs-ID: ZL1_OL38
Längd: 2 dagar
Pris exkl moms: 14 500 kr
Inregistrering: 09.00
Kursstart: 09.30
Kursslut (ca): 16.30

Frågor om kursen?

Har du frågor om kursens innehåll, leveransdatum/ort eller behöver en företagsanpassad variant? Fyll i formuläret nedan!


Kan betalas med:
TRAINING CARD

Avtalsrabatter och kampanjer kan ej nyttjas på denna kurs.


Ort och datum

Stockholm
18 maj-19 maj
Boka nu!

Tipsa