SW711: Accessing DB2 UDB for iSeries from Java Programs

This Web-based training course is about writing Java programs that access a database on the IBM eServer iSeries server - DB2 UDB for iSeries. This database is a member of IBM's DB2 family of products. It has some unique characteristics that an application developer needs to be aware of.

To simplify and streamline the development of such applications, you'll use an excellent development tool called WebSphere Development Studio Client Advanced Edition for iSeries V5.0.1.

• Register now or sign in using your IBM ID and password

This course teaches you to write Java programs that access DB2 UDB for iSeries. You'll use a development environment called WebSphere Development Studio Client for iSeries to accomplish this task. The course approaches this topic from 4 directions:

• Providing a quick introduction to JDBC technology and iSeries specific details to access DB2 UDB on iSeries. This part of the course is essential to understand the rest of the course.
• Showing a technology called Program Call Markup Language (PCML) to invoke a host program on iSeries.
• Explaining the available tools to help you develop an application with a database access to iSeries.
• Optimizing your application for the best performance on iSeries.

Audience

This course is designed for software developers, consultants and architects.

Objectives

After completing this course, students should be able to:

• Discuss the JDBC technology.
• Describe the database access methods from a Java program.
• Describe the unique features of Java programming to access DB2 UDB for iSeries.
• Optimize your Java programs to access DB2 UDB for iSeries.
• Use the Data tools in WebSphere Development Studio Client for iSeries V5.0.1.

Prerequisites

You should demonstrate the following knowledge in order to complete this course successfully:

• Basics of Java programming language.
• Basics of Structured Query Language (SQL).
• Understanding of eXtensible Markup Language (XML).
• Basics of the iSeries work management.

System requirements

• This course requires Microsoft® Internet Explorer version 5 or greater.

Duration

How long it takes you to complete the course depends upon your reading speed, and how many units you complete. Each module typically takes forty to sixty minutes to read. Demonstrations typically last five to fifteen minutes. Therefore, you can allow an average of a seventy minutes for each module.

One benefit of a self-paced course is that you can take it a portion at a time. Allocating some time each day for a week may be more a effective approach to completing this course than setting aside an entire day.

Languages

English