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.