MP9005: Web Development - Row and Table Manipulation > Building Sites and Site Collections

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. 

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

Objectives:
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

Duration:
3 Hours