O'Reilly logo

DB2® for z/OS® Version 8 DBA Certification Guide by Susan Lawson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Retrieving and Manipulating Database Objects

• Data retrieval: Basic SELECT statements

• Data modification: INSERT, UPDATE, and DELETE

Chapter 4 discussed the definitions of various database objects, using the Data Definition Language (DDL). In this chapter, we start manipulating the database objects, using the portion of SQL known as Data Manipulation Language (DML). We populate (insert) data into the database and retrieve the data, using many powerful methods. Depending on their sophistication, the database users can use SQL to query the database. The majority of the SQL statements within a DB2 application involve DML statements. Therefore, application developers must understand the various methods of inserting, updating, and retrieving ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required