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 ...
Get DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
