DB2 UDB Programming

Course Number: 704-JK
Recommended Duration: 5 days

Intended Audience: Java, C#, COBOL, PL/I, or C programmers who need to work with DB2 UDB Databases.

Objectives

Students who complete this course will be able to code SQL statements to access DB2 UDB objects by typing SQL and from within application programs (in the student's standard host environment). Students also learn to execute and test DB2 UDB programs.

DB2 UDB Version 8.1. Most of the class is suitable for those earlier versions of DB2 UDB (DB2 UDB 7).

Prerequisites

The student should have 6 months experience designing and coding Java, C#, COBOL, or C application programs or have completed the appropriate course within the last 12 months. Familiarity with the available editor is required.

Topics

• Relational database concepts
• DB2 UDB concepts
• DB2 Clients: Run-time, Administration, SDK
• SQL
• Control center
• Command line processor
• SELECT
• UPDATE/DELETE/INSERT
• COMMIT/ROLLBACK
• Joins and Subqueries
• Functions
• Analytic features
• Creating tables, views, materialized query tables
• System catalog tables
• SQL in application programs
• Host variables and structures
• Cursors and locks
• Security and authorization
• DB2 Extenders
• DB2 connect
• Database administration server
• Dynamic SQL
• Stored procedures
• Efficiency considerations

Share with others

Can't Read? Click to Generate New Code

Enter the verification code shown above into the text box below