Canada's Leader in Professional Development

855-581-7246 Call us: 416-368-7246 ext 2

IBM DB2 9 for Linux, UNIX and Windows Application Programming Advanced

Currently no upcoming Class Dates


This is the Classroom version of Instructor-led online course DB2 9 for Linux, UNIX and Windows Application Programming Advanced (ILO) (3L110).

This course teaches how to take advantage of advanced programming techniques to access DB2 databases in the workstation environment. These techniques can be utilized in addition to standard embedded SQL calls that are addressed in the prerequisite offering,DB2 UDB Programming Fundamentals. These advanced techniques include:

  • Stored Procedures
  • User-Defined Functions
  • Application Programming Interfaces (APIs)

Performance concepts are also addressed.


  • Use object-relational capabilities of DB2 UDB such as LOB manipulation, user-defined functions, and user-defined distinct types
  • Code stored procedures and call such procedures
  • Use product-defined Application Programming Interfaces (APIs)


This advanced course is for application programmers and other technical personnel who are involved in designing and implementing applications that access DB2 data from a workstation environment.


The following prerequisites are suggested:

  • The ability to code embedded, static SQL applications
  • Familiarity with relational database concepts
  • Use of basic C language syntax components

These skills can be developed by taking:

  • Introduction to C Programming
  • DB2 UDB Programming Fundamentals

Equivalent experience may be substituted for these courses.

Application programming experience with other relational database systems, such as DB2 MVS, DB2/VSE and VM, and DB2/400, would be appropriate for meeting the DB2 prerequisites.


2 days


  • Introduction and Static Review
  • Stored Procedures
  • Introduction to Call Level Interface (CLI)
  • Using Object-Relational Capabilities
  • Application Programming Interfaces

Click here to reach us by Email Contact Us
About | Terms of Use | Privacy Visit our Facebook page   Visit ot Linkedin page   View our Tweets