Purpose
This course teaches students how to take advantage of intermediate programming
techniques to access DB2 databases in the workstation environment. These techniques
can be utilized in addition to standard embedded SQL call that are addressed in the
prerequisite offering, DB2 UDB Programming Fundamentals.
Audience
Application programmers and other technical personnel who are involved in designing
and implementing applications that access DB2 data from a workstation environment.
Prerequisites
Before taking this course, students should be able to:
Code embedded, static SQL applications
Discuss relational database concepts
Use basic "C" language syntax components
This skill 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.
Objectives
After completing this course, students should be able to:
Use Object-Relational capabilities of DB2 UDB such as LOB manipulation, User-Defined Functions, and User Defined Distinct Types
Code dynamic SQL applications
Code stored procedures and call such procedures
Use product defined Application Programming Interfaces (APIs)
Identify factors that influence application performance of alternatives to static SQL
Contents
Introduction and Static Coding Review
Dynamic SQL Programming
Stored Procedures
Introduction to Call Level Interface
Object-Relational Capabilities
Application Programming Interfaces (APIs)
Performance Considerations for Alternatives to Static SQL
This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.