Summary

In this chapter, we 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 covered many of the basic functions of SQL statements, including 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

If you are a business analyst, you may expect more analytical, ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application 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.