I/S Resource Group: Introduction to DB2 UDB for UNIX, Training, Universal, UNIX, Windows, DB2, Relational, database, SELECT, SQL, INSERT, UPDATE, DELETE, join, outer, query, table, view, cursor, dynamic, catalog, embedded, static, CLI, command, window, control, center

Introduction to DB2 UDB for UNIX

Abstract
(5 Days)

This course introduces application programmers to IBM’s DB2 UDB for UNIX. It covers basic database structure, database access through various user interfaces, data access through SQL and application programming.

Audience

This course is open to any application programmer. A familiarity with SQL is beneficial.

Topics

DB2 UDB architecture
- Databases
- Containers
- Tablespaces
- Instances
DB2 UDB schemas
- Object ownership
DB2 database connections – CONNECT TO
DB2 interfaces
- CLP – command line processor
- Command Center
SQL issues
- Datatype differences including autonumber
- Scalar function differences including date, type conversions, etc.
- Join differences (updates not allowed)
- Join syntax
- FETCH FIRST n ROWS
UDB error handling/bad data – SQLCODE,SQLCA
Cursor processing
Dynamic SQL
Stored procedures
- Syntax
- Preparation/compilation
- Languages – SQL, C, etc.
- Stored procedure language elements
- Control structures – IF,DO, etc
- Variables
- Overloading
User-defined functions (UDFs)
Triggers
UDB Utilities
- LOAD
- IMPORT
- EXPORT
UDB security and privilege
- Using dynamic SQL to handle privilege issues in a C/S environment
- Privilege issues with stored procedures

Supervised Exercises

Each day, the class sessions will be accompanied by a set of written/programming exercises designed to reinforce the classroom material. Lab time will form a significant portion of this course.