Level: Introductory Pat Moffatt (pmoffatt@ca.ibm.com), Information Management Program Manager, IBM Academic Initiative, IBM
Bruce Creighton (bcreight@ca.ibm.com), Skills Segment Planner, IBM
Jessica Cao , Training Tools Developer, IBM
03 Aug 2006 Through a series of simple examples, this tutorial illustrates how to retrieve data from an IBM® DB2® database with standard SQL SELECT statements. This tutorial describes how to retrieve rows from a relational database table, retrieve specific columns, retrieve specific rows, reform logical operations on retrieved data, and use wildcard characters in search conditions. This tutorial is Part 2 of the SQL & XQuery tutorial for IBM DB2 series.
Prerequisites
This tutorial was written for DB2 Express-C 9 for UNIX®, Linux® and Windows® (formerly known as Viper). You should be familiar with DB2 and databases. It is preferable that you view tutorial one in this series before attempting this tutorial, part 2.
System requirements
To use this tutorial to the fullest, you should have IBM DB2 9 installed. Download DB2 Express-C, a no-charge version of DB2 Express Edition for the community that offers the same core data features as DB2 Express Edtion and provides a solid base to build and deploy applications. You will also need to install the Aroma database, which can be downloaded in the tutorial.
Duration
Under 2 hours
Formats html, pdf
About this tutorial
This tutorial series teaches basic to advanced SQL and basic XQuery topics and shows how to express commonly asked business questions as database queries by using SQL queries or XQueries. Developers and database administrators can use this tutorial
to enhance their database query skills. Academic Initiative members can use this tutorial series as a part of their database curriculum.
Using a series of simple examples, this tutorial illustrates how to retrieve data from an IBM DB2 database with standard SQL SELECT
statements.
This tutorial describes how to:
- Retrieve rows from a relational database table
- Retrieve specific columns from a relational database table
- Retrieve specific rows from a relational database table
- Perform logical operations on retrieved data
- Use wildcard characters in search conditions
| 
