Kursbeskrivning: Developing iSeries Applications Using SQL

This course is designed to teach experienced AS/400 RPG programmers how to:

• use embedded SQL in AS/400 RPG IV programs
• explain the use of SQL Stored Procedures
• explain the use of the Call Level Interface

Visa den här kursen i andra länder

Tillbaka till toppen

This course is designed for experienced AS/400 RPG programmers who want to learn how to use SQL as an alternate means to access the AS/400 database in their applications.

Tillbaka till toppen

Before attending this class, the student should be able to:

• use SQL Data Definition Language (DDL) to describe tables and views
• use SQL UPDATE, INSERT, ALTER and DELETE statements to modify SQL tables
• use the SQL SELECT statement to extract data from tables and views
• code SQL queries that include column and scalar functions
• code SQL queries that include inner and outer joins
• navigate AS/400 menus and use AS/400 commands
• use PDM and SEU to code programs
• use the ILE Source Debugger
• code RPG programs on the AS/400

Experience coding applications in the RPG IV language is strongly recommended but RPG III background is acceptable. RPG IV language features will not be taught.

Tillbaka till toppen

After attending this class, the student should be able to:

• code embedded SQL statements in RPG IV programs
• explain the use of Stored Procedures
• explain how the Call Level Interface can be used

Tillbaka till toppen

The course units are:

• SQL Review
• Using Embedded SQL
• An Overview of Stored Procedures
• Introducing the SQL Call Level Interface

Tillbaka till toppen