Total Time: 3 hour(s)

Summary: 
This course provides an overview of the use of DB2 and how to use it to change and manipulate data in DB2 rows and tables to affect the outcome of COBOL programs.

Ojectives: 
After completing this course, students will be able to:
Select and retrieve a single row of data
Operate Working Storage to receive VARCHAR columns
Select and retrieve multiple rows of data
Use the FETCH statement to bring multiple rows into the application
Create direct table updates
Create indirect table updates
Locate column values

Topics: 
Selecting a Single Row
Referencing Data
Selecting Multiple Rows
Fetching Rows
Direct Table Updates
Indirect Table Updates
Updating Column Values

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.