Summary

In this chapter, we have discussed the Data Manipulation Language (DML). DML has four primary statements: SELECT, UPDATE, INSERT, and DELETE. These statements enable all database object data manipulation.

The knowledge of basic SQL is mandatory for a DB2 database administrator and application developer. However, SQL is very powerful language, and the level of SQL will vary depending on the user's primary activity.

In this chapter, we cover many of the basic functions of SQL statements. We looked at how to:

  • retrieve rows

  • sort the result set

  • restrict the result with some conditions

  • retrieve rows from more than one table at a time

  • add a row to a table

  • remove a record

  • change the value of the table

  • and more.

If you are a business analyst, you may ...

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide 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.

Start your free trial