Summary

Team-Fly    

 
DB2 Universal Database for OS/390 v7.1 Application Certification Guide
By Susan Lawson
Table of Contents
Chapter 3.  Basic SQL Coding

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, statistical information from DB2. DB2 supports very powerful SQL functions for various business needs. We'll talk about some advanced SQL in the next chapter.


Team-Fly    
Top


DB2 Universal Database for OS. 390 v7. 1 Application Certification Guide
DB2(R) Universal Database for OS/390 V7.1 Application Certification Guide (IBM DB2 Certification Guide Series)
ISBN: 0131007718
EAN: 2147483647
Year: 2002
Pages: 163
Authors: Susan Lawson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net