The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 UDB V8.1 Family Application Development Certification: Database objects and programming methods

Get ready for the exam

Clara Liu (claraliu@ca.ibm.com), DB2 UDB consultant, IBM

Clara Liu works as a DB2 UDB consultant at the IBM Toronto Laboratory. As a member of the Data Management Channel Development Team, she works closely with IBM business partners. Clara specializes in database application development and integration of new technologies with DB2. She teaches DB2 UDB certification courses to IBM business partners and at conferences. She co-authored the book DB2 SQL Procedural Language for Linux, UNIX, and Windows . You can reach Clara at claraliu@ca.ibm.com.

Summary: This tutorial introduces different types of database objects and programming methods. This is the first tutorial in a series of seven tutorials that you can use to help prepare for the DB2 UDB V8.1 Family Application Development Certification exam (Exam 703).

Date: 18 Mar 2004
Level: Introductory
PDF: A4 and Letter (165 KB | 27 pages)Get Adobe® Reader®

Activity: 6565 views
Comments:

Before you start

What is this tutorial about?

This tutorial introduces different types of database objects and programming methods. In this tutorial, you will learn about:

Different types of database objects
The relationship between schemas and database objects
The fundamentals of SQL routines
The basics of dynamic and static embedded SQL
The basics of CLI and ODBC
The basics of ADO and OLE DB
The basics of JDBC and SQLJ
The security considerations associated with data access from an application

This is the first in a series of seven tutorials that you can use to help prepare for the DB2 UDB V8.1 Family Application Development Certification exam (Exam 703). The material in this tutorial primarily covers the objectives in Section 1 of the exam, entitled "Database objects and programming methods." You can view these objectives at: http://www.ibm.com/certify/tests/obj703.shtml.

You do not need a copy of DB2 Universal Database to complete this tutorial. However, you can download a free trial version of IBM DB2 Universal Database from the developerWorks downloads page for reference.

Who should take this tutorial?

To take the DB2 UDB V8.1 Family Application Development exam, you must have already passed the DB2 UDB V8.1 Family Fundamentals exam (Exam 700). You can use the DB2 Family Fundamentals tutorial series (see Resources) to prepare for that exam. It is a very popular series that has helped many people understand the fundamentals of the DB2 family of products.

Although not all materials discussed in the Family Fundamentals tutorial series are required to understand the concepts described in this tutorial, you should have a basic knowledge of:

DB2 instances
Databases
Database objects
DB2 security

This tutorial is one of the tools that can help you prepare for Exam 703. You should also review the Resources at the end of this tutorial for more information about database objects and programming methods.

Notices and trademarks

IBM, DB2, DB2 Universal Database, DB2 Information Integrator, WebSphere and WebSphere MQ are trademarks or registered trademarks of IBM Corporation in the United States, other countries, or both.

Other company, product, and service names may be trademarks or service marks of others.

Comments