This course is not scheduled. Inquire about Onsite training at your facility.
Overview
| Course code | OL390 | Skill level | Advanced |
|---|---|---|---|
| Duration | 3.0 days | Delivery type | Classroom
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price | USD $2,000.00 plus tax | ||
Learn how to use triggers and SQL stored procedures in DB2 UDB. Learn about the object relational support of DB2 UDB for iSeries and AS/400e, including support of Large Objects (LOB), user-defined types, user-defined functions and datalinks. Coding examples and machine exercises use the Integrated Language Environment (ILE) RPG IV and ILE C languages.
View this course in other countries
Training Paths that reference this course are:
Audience
This advanced course is for experienced iSeries and AS/400e programmers who write applications that use SQL to access the database.
Prerequisites
You should complete:
or 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, and use the SQL SELECT statement to extract data from tables and views;
or be able to navigate iSeries and AS/400e menus and use commands and use the operations navigator for database related topics;
- Moving from RPG/400 to iSeries RPG IV (S6126) or (OE850) or
- System i RPG IV Version 5 Programming Fundamentals Workshop (S6197) or (AS060)
- System 1 RPG IV Version 5 Programming Intermediate Workshop (S6198) or (AS070)
or be able to use the ILE source debugger and code RPG IV or C programs on the iSeries or AS/400e.
Skills taught
- Define and code triggers in DB2 UDB for iSeries and AS/400e
- 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
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
