Chapter 5. Retrieving and Manipulating Database Objects

• Data retrieval: Basic SELECT statements

• Data modification: INSERT, UPDATE, and DELETE

Chapter 4 discussed the definitions of various database objects, using the Data Definition Language (DDL). In this chapter, we start manipulating the database objects, using the portion of SQL known as Data Manipulation Language (DML). We populate (insert) data into the database and retrieve the data, using many powerful methods. Depending on their sophistication, the database users can use SQL to query the database. The majority of the SQL statements within a DB2 application involve DML statements. Therefore, application developers must understand the various methods of inserting, updating, and retrieving ...

Get DB2® for z/OS® Version 8 DBA Certification Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.