Developing iSeries Applications Using SQL

2 Day Course
Hands On
Official IBM Curriculum
Code OL38GB

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

Cross-training for experienced RPG programmers ­learn to use embedded SQL as an alternative to traditional file processing.

Suitable for experienced RPG programmers with a basic understanding of the SQL language.

After attending this course, students should be able to:

  • Code embedded SQL statements (static and dynamic) in RPG programs to perform database I/O operations
  • Explain the use of SQL Stored Procedures

Each student will have a dedicated workstation to complete the numerous practical exercises. Sample solutions will also be provided.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Applications Using SQL (4 topics)

  • Review of the SQL language
  • Coding Static SQL statements in RPG IV programs
  • Coding Dynamic SQL statements in RPG IV programs
  • SQL Stored Procedures

Prerequisites

Before attending this course, students should be able to: Write SQL DDL statements for maintaining the iSeries DB2 UDB database Write SQL DML statements for the retrieval and manipulation of information stored in the iSeries DB2 UDB database. These skils can developed by attending the following courses: OL49I - iSeries Technical Introduction OL37 - Accessing the iSeries Database Using SQL

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

  • i5/OS (OS/400) Technical Introduction

    3 Day IBM Course on i5 OS/400 - Introductory Course on the functions integrated with the i5 Series Operating System.

    3 Day Course Official Curriculum Course Code OL49IGB
    Scheduled Online Onsite
  • Accessing the iSeries Database Using SQL

    2 Day IBM iSeries Database Course - A practical introduction to the use of the SQL Language to access DB2 UDB for iSeries

    2 Day Course Hands On Training Official Curriculum Course Code OL37GB
    Scheduled Online Onsite

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections