Good work! This tutorial taught you how to create a simple DB2 SQL query by using the SQL builder.
Lessons learned
By completing this tutorial,
you learned about the following concepts and tasks:
- How to create a SELECT statement
- How to add tables to the statement
- How to add table aliases
- How to specify result columns
- How to add a CASE expression to the result column set
- How to add a column alias
- How to join tables
- How to create a query condition
- How to add a GROUP BY clause
- How to run the DB2 SQL query
and pass in a host variable for the query