Summary
In this chapter, we have discussed the DML as it pertains to data manipulation. The DML statements that allow you to manipulate data are the statements: UPDATE, INSERT, and DELETE. Knowledge of basic SQL is mandatory for a DB2 database administrator and application developer. However, SQL is a very powerful language, and the level of SQL will vary depending on the user's primary activity.
We have also taken an important look at views. Views allow you to not only control which data is available to a user, but also to provide ready-to-view queries. We also have taken an in-depth look at the rules that allow views to be deletable, updatable, insertable, and read only.
Manipulating data objects is an important skill for the application developer ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd 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.
