DB2 UDB for iSeries SQL Adv. Programming (OL39)

Format

Classroom

Duration

4.0 Day(s)

Description

This class is designed for AS/400 programmers who want to learn how to use triggers and SQL Stored Procedures in DB2 UDB for AS/400.
It also teaches the object relational support of DB2 UDB for AS/400 including support of LOBs, User Defined Types, User Defined Functions and Datalinks.
Coding examples and machine exercises use the ILE RPG IV and ILE C language

Audience

This course is designed for experienced AS/400 programmers who have experience writing applications that use SQL to access the database.

Prerequisites

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
- Navigate AS/400 menus and use AS/400 commands
- Use the operations navigator for Database related topics.
- Use PDM and SEU to code programs
- Use the ILE Source Debugger
- Code RPG IV and/or C programs on the AS/400
These skills can be obtained by attending these courses:
- S6145/OL45 - DB2 UDB for AS/400 Fundamentals
- S6149/OL49 - AS/400 Application Programming Facilities Workshop
- S6137/OL37 - Accessing the AS/400 Database Using SQL
- S6109/OL86 - AS/400 RPG IV Programming Workshop
or
- S6126/OE85 - Moving from RPG/400 to RPG IV
- S6138/OL38 - Developing AS/400 Applications Using SQL
or via equivalent experience.
The classes are shown in the suggested sequence in which they should be attended.

Objectives

After completing this class, the student should be able to:
- Define and code triggers in DB2 UDB for AS/400
- Code advanced features of SQL procedures, including writing error handling, and, handling and passing result sets
- Define and use LOBs
- Define and use User Defined Types
- Define and use User Defined Functions
- Define and use Datalinks

Contents

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