|
Provided by: Serebra Learning Corporation DB2 Application Programming II Rel 4 xDB2 |
 |
Training
Provided by Serebra Learning Corporation
This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2. Application developers
|
|
||||||||||
DB2 Application Programming II Rel 4 x
Audience
Application developers
Topics
Data Modification
- INSERT single or multiple rows of data
- Data modification
- INCLUDE PROJECT statement
- INSERT statement
- INSERTing multiple records
- Referential integrity rule
- INSERT
- DELETE a row of data
- The DELETE statement
- Referential Integrity rule
- DELETE
- UPDATE data
- The UPDATE statement
- Referential integrity rule
- UPDATE
- ERROR and WARNING conditions
- Program system errors
- The WHENEVER statement
- Error checking
Retrieval Cursors
- Defining a cursor
- Opening a cursor
- Process overview
- Accessing multiple rows
- The OPEN cursor statement
- Fetching a row
- The FETCH statement
- FETCH example
- Advancing the cursor
- Stop fetching rows
- Stop fetching rows example
- Closing the cursor
Objectives
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
