Chapter 5. Retrieving and Manipulating Database Objects
• Data retrieval: Basic
• Data modification:
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 ...