Training offering

DB2 UDB for System i SQL Advance programming

Information

Length:	1 Day
Course code:	OL39GB
Price	£1,200 before tax

Download

Session dates

Date	Location

11/06/2012

London
£1,200 before tax

This training is also available as onsite training.
Please contact us on
0870 251 1000 or email training@arrowecs.co.uk
for more information.

Description

•    OL49 - iSeries Application Programming Facilities Workshop

•    OL37 - Accessing the iSeries Database Using SQL

Application programmers who attend should also be able to:
•    Use PDM and SEU or CODE/400 to develop applications

•    Use the ILE Source Debugger

•    Code RPG IV (and / or C) programs on the iSeries

Application programming skills can be obtained by attending these classes:
•    OL86 - iSeries RPG IV Programming Workshop

or
•    OE85 - Moving from RPG/400 to RPG IV

or
•    AS06 - RPG IV Version 5 Programming Fundamentals Workshop

•    AS07 - RPG IV Version 5 Programming Intermediate Workshop

and
•    OL38 - Developing iSeries Applications Using SQL

Objectives

This class is primarily designed to teach the students how to code SQL Triggers and SQL Stored Procedures in DB2 UDB for iSeries. It also teaches the object relational support of DB2 UDB for iSeries including support of LOBs, User-Defined Types, User-Defined Functions, and Datalinks.

Participants

Programmers.

Prerequisite(s)

This course is designed primarily for experienced iSeries application programmers who have experience writing applications that use embedded SQL to access the database. SQL users who have experience in coding complex SQL queries may also benefit from the class.

Options

1. SQL Triggers
2. SQL Stored Procedures
3. Large Object Support
4. User-Defined Types
5. User-Defined Functions
6. DataLinks