RPG IV Programming: Integrating RPG IV and SQL (course 3)

Dates Scheduled: 10/20/2010

Length: 1 Day / Time: 9:00A - 5:00P

Delivery Method: Instructor led, group-paced, classroom delivery learning model with structured hands-on activities.

Cost: $495.00

Course Description: This RPG programming training workshop investigates ways to combine the unique powers of RPG IV and SQL development environments to provide even more flexibility and functionality.

Course Objective: You will learn how to enable SQL and RPG to complement one another in a business application, especially when one is better suited for a particular task than the other.

Target Student: This course is designed for programmers who have become proficient in the RPG IV language and are seeking better ways for their applications to harvest data.

Prerequisites: RPG IV Programming: Fundamentals or comparable experience.

Performanced-Based Objectives: Upon Successful completion of this course, students will be able to:

• Write SQL queries from scratch
• Recognize the advantages of SQL over DDS and Query
• Perform database updates with SQL
• Access SQL function using several different System/i interfaces
• Get SQL and RPG to play nicely in the sandbox
• Make inquiry and report rograms more user driven
• Combine data from multiple files for processing
• Make informed decisions whether RPG or SQL is better for a given task

Course Content: Full Course Outline

SQL crash course
Embedding SQL inside RPG
Host variables
The SQL pre-compiler
Using result sets
Eliminating "F" specifications
Building dynamic SQL
SQL works best when you say UNION yes
Performance considerations