Chapter 5. Data Modification

In Chapter 4 you learned how to query data from DB2 databases. In this chapter, you are going to learn how to INSERT, UPDATE, and DELETE data from the database. These three SQL statement types are also part of the DML and complement the SELECT statement. All that you learned about the WHERE clause from the previous chapter also applies to the UPDATE and DELETE statements. It can be used to identify which rows in a table you want to modify. This chapter also discusses the concept of a VIEW and the rules for its use, in particular when it comes to modifying the data behind the view.