Chapter 4. Data Retrieval
Chapter 3 discussed the various definitions of data objects. These objects were created and defined using the Data Definition Language (DDL). This chapter takes those objects and demonstrates how to retrieve data from them using the Data Manipulation Language (DML) as defined by SQL. This chapter looks at the SQL statement types, SELECT and CALL. The CALL statement is covered at the end of the chapter and can be used to invoke a stored procedure that resides on the server. A stored procedure can return one or more result sets. This chapter primarily covers SELECT and how the resulting data can be grouped and ordered. As the examples progress through the chapter, they will demonstrate more complex methods of data retrieval. ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition 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.
