IBM i - IBM OL38G - Developing IBM i Applications Using SQL

Standort:

Termin:

1.490,00 € *

zzgl. MwSt.

Preis inkl. gesetzlicher MwSt.: 1.773,10 €
IBM OL38G - Developing IBM i Applications Using SQL Kurssprache ist deutsch, die Unterlagen... mehr

IBM OL38G - Developing IBM i Applications Using SQL

Kurssprache ist deutsch, die Unterlagen sind in englischer Sprache.
This course is designed for experienced IBM i RPG IV programmers who want to learn how to use SQL as a means to perform I/O to access the DB2 UDB for IBM i database in their applications.
This course is designed primarily to teach experienced IBM i RPG IV programmers how to use embedded SQL in IBM i RPG IV programs. As a secondary purpose, you will also learn to create and use simple SQL Stored Procedures.
Hinweis: Dieses Seminar wird in Zusammenarbeit mit dem offiziellen Partner des IBM Global Training Providers Global Knowledge: Integrata AG oder dem IBM Education Delivery und IBM Sales Partner von Arrow ECS: Fast Lane Institute for Knowledge Transfer GmbH durchgeführt.

Inhalt

Welcome and Administration
SQL Review
Using Embedded SQL
Introducing Embedded SQL
Writing Programs that Use Embedded SQL
Error Handling
Using a Cursor for Multiple Row Result Set
Using Embedded SQL (continued)
Optional Additional Lab Time
Dynamic Embedded SQL
An Overview of Stored Procedures
Introducing Stored Procedures
External Stored Procedures
Machine Exercise - Create a Stored Procedure
SQL Stored Procedures

Voraussetzungen

Experience with coding applications in the RPG IV language is strongly recommended but RPG III background is acceptable. RPG IV language features will not be taught. If you have no knowledge of RPG IV, you may get less value from this class than would an experienced RPG IV programmer.
Overview knowledge of the DB2 UDB for IBM i database can be obtained by attending the following course IBM i Datenbank - DB2 und SQL kompakt (OIDB02DE).

Zielgruppe

This course is designed for experienced IBM i RPG IV programmers who want to learn how to use SQL as a means to perform I/O to access the DB2 UDB for IBM i database in their applications.

Zielsetzung

This course is designed primarily to teach experienced IBM i RPG IV programmers how to use embedded SQL in IBM i RPG IV programs. As a secondary purpose, you will also learn to create and use simple SQL Stored Procedures.