IBM i RPG IV Programming with SQL Workshop

Course Details Course code: SQLP Duration: 2 days Maximum delegates: 10 Start time: 09:30 Price: P.O.A.

Jump to: Introduction What you will learn Who should attend Pre-requisites Course content Schedule Actions: Print data sheet Book course Book on-site/mobile

Introduction

Rapidly changing business requirements mean that applications for the IBM i can no longer be developed exclusively in the RPG IV and CL programming languages.

Looking to the future, these core facilities have to be complemented by other tools. SQL provides such additional capabilities for enhanced database access and functionality.

This practical Workshop will enable experienced RPG IV programmers to develop the skills to incorporate SQL statements in their programs where appropriate.

Who should attend

Experienced RPG IV Developers.

Pre-requisites

A basic working knowledge of the SQL language is required, this can also be obtained by attending our
SQL Foundation Workshop. Delegates should be familiar with the IBM i platform and have practical experience with the commands and tools relevant to application development and maintenance. A good knowledge of RPG IV programming is essential; experience with the Rational Developer for IBM i tooling would be an advantage.

Attendees will require authority to create their own Schemas (Libraries), Tables (Physical Files), etc.
Source scripts will be provided to create a simple database for subsequent data manipulation.

Attendee's PC's should be fully configured as detailed in a seperate "Checklist" which can be obtained on request. or once a booking has been made.

Topics Covered

• Introduction and Recap.
• Coding Principles.
• Static SQL: No Cursor
• Static SQL: With Cursor
• Dynamic SQL: Non-SELECT
• Dynamic SQL: Fixed List SELECT
• Dynamic SQL: Varying List SELECT
• Introduction to Stored Procedures
  
  A more detailed Outline of this 2 day Workshop is available on request.
  
  This Workshop is aimed at being delivered on customer site,
  
  

Schedule