DB2® Universal Database for OS/390® Version 7.1 Certification Guide

Chapter 5. Manipulating Database Objects

• Data Manipulation Language

• Retrieving Data

• Inserting Data

• Updating Data

• Deleting Data

In the previous chapter, we 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 will be populating (inserting) data into the database and retrieving the data using many powerful methods. Depending on the sophistication of the database users, they can use SQL to query the database. The majority of the SQL statements within a DB2 application involves DML statements. Therefore, application developers must understand the various methods of inserting, updating, ...