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.

Brand: Power Systems; IBM i

Event Number: OL38G

Available Languages: English (US),English (UK),French (Canada),German (Germany),Russian (Russia),Japanese (Japan),Chinese (Simplified),Italian (Italy),Polish (Poland),Portuguese (Brazil),French (France),Spanish (Latin America),Spanish (Spain),Portuguese (Portugal),Thai (Thailand),Dutch (The Netherlands),Turkish (Turkey),Romanian (Romania),Czech (Czech Republic),Latvian (Latvia),Lithuanian (Lithuania),Norwegian (Bokml),Swedish (Sweden),Danish (Denmark),Hebrew (Israel),Arabic,Greek (Greece),Korean (Korea),Bulgarian (B

Subjects: Technical

Objectives:

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

Learn about;
IBM Operating Systems;
IBM i;
IBM i 7.1

Course Detail:

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

Pre-Requisite Text:

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)

No Sessions available at this moment
Please contact your local Training Administrator to schedule this class
Or, Chat With Us in the lower right corner of the page