IBM i on POWER, IBM i, System i, i5, iSeries, AS/400 Training Classes

			Assignment 400 Group, Inc.
Home	Corporate Profile	Contact	Telephone: 770.321.8562
			e-mail: inquiry@assignment400.com

Training and Classes

Classes for your IBM i, System i, iSeries or AS/400?

Many programmers working on the IBM iFamily have been using RPG III and RPG IV in a limited way. For many companies, the code on their systems was provided by the vendor of their solutions. For various reasons, many companies chose to freeze their versions of the solution software they use. As a result, the code is dated and does not make use of ILE and SQL functions.

A4G developed the following classes to meet this need and assist companies and their developers to start using the power of ILE, Free Form RPG and SQL.

Class details.

Class	Class Details	Description - Class covers	Duration
	RPG
RPG101	RPG ILE and Free Form overview. Click here to request a class.	History of RPG and OPM (Original Program Model) What is ILE? New ILE formats Introduction to Free Form RPG Differences between C-Specifications and Free Form Compile options New Free Form Operation codes Gotcha's Subroutines, sub procedures and functions Example programs	1 Day
RPG201	RPG ILE and Free Form class with Lab sessions. Click here to request a class.	What is RPG (for non RPG folk)? What is ILE? New ILE formats How to convert OPM programs into ILE programs. What is Free-form RPG? Basics Similarity to other languages Debugging Built in Functions (BIF’s) Gotcha’s Subroutines, sub procedures and functions Service Programs Building modules and binding modules into 1 or more programs Basic API integration	2 Days
	SQL
SQL101	Introduction to SQL and its usage in RPG on your IBM iFamily and AS/400. Click here to request a class.	What is SQL? Why SQL? What, no DDS SQL Objects, tables, views, indexes Interactive SQL and iNavigator SQL usage Compiling options C-Spec SQL Free Form RPG with SQL Debugging Built in functions (BIF's) PRTSQLINF	Half Day
SQL201	RPG ILE with SQL class with Lab sessions. Click here to request a class.	What is SQL? Why SQL? What, no DDS? Different types of SQL tools SQL Objects Compiling options C-Spec SQL Free Form SQL Removal of F Specs File processing Basic Defining cursors Sensitive and insensitive cursors Updates, adding and deleting from tables Dynamic SQL Debugging Accessing DB2/400 from non AS/400 systems MS SQL, mySQL, PHP PRTSQLINF Authorizing users/permissions	2 Days

Click here to see class information, locations, schedules, requirements and requisites.

A4G is a full-service Solutions Provider of equipment and services. From systems reviews to system design and equipment recommendations, system integration and ongoing maintenance, count on A4G to be your value-added partner. Contact A4G today for a free quotation.

The IBM logo is a trademark and the IBM Business Partner emblem is a trademark of International Business Machines Corporation in the United States, other countries, or both.