EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

OL391MY- DB2 UDB for System i SQL Advanced Programming

Course outline

3 days
Discuss this programme →

Duration

3 days

Audience

This course is 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.

Prerequisites

You 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 iSeries menus and use iSeries commands
  • Use the iSeries Navigator for Database tasks including RUN SQL Scripts

These skills can be obtained by attending these courses:

  • DB2 UDB for iSeries Fundamentals (OL45)
  • iSeries Application Programming Facilities Workshop (OL49)
  • Accessing the iSeries Database Using SQL (OL37)

The courses are listed in the suggested sequence in which they should taken. Please consult your local IBM ILS education center for guidance.

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:
  • iSeries RPG IV Programming Workshop (OL86)

or

  • Moving from RPG/400 to RPG IV (OE85) or
  • RPG IV Version 5 Programming Fundamentals Workshop (AS06)
  • RPG IV Version 5 Programming Intermediate Workshop (AS07)

and

  • Developing iSeries Applications Using SQL (OL38).

Course Objectives

  • 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

Course Content

  • SQL Triggers
  • SQL Stored Procedures
  • Large Object Support
  • User-Defined Types
  • User-Defined Functions
  • DataLinks

Programme scope, delivery arrangements and suitability are confirmed during enquiry.