O'Reilly logo

DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition by Paul C. Zikopoulos, George Baklarz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. Manipulating Database Objects

• DATA MANIPULATION LANGUAGE

• RETRIEVING DATA

• INSERTING DATA

• UPDATING DATA

• DELETING DATA

• MERGING DATA

• VIEW CLASSIFICATION

In the previous chapter, we discussed the definition of various database objects using the Data Definition Language (DDL). In this chapter, we start manipulating database objects using the part 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. 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 data from the database. We will ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required