Modernizing IBM eServer iSeries Application Data Access - A Roadmap Cornerstone

Chapter 10. DB2 Development Tools 231

Figure 10-7 Construct an SQL statement

7. Figure 10-8 shows the Create Join window, in which we select the source and target table,

column, and join type.

Figure 10-8 Join conditions

232 Modernizing IBM Eserver iSeries Application Data Acess - A Roadmap Cornerstone

8. Click Next. The constructed SQL statement is shown (Figure 10-9). You can run the SQL

statement by clicking Execute.

Figure 10-9 The SQL statement

9. Figure 10-10 on page 233 shows the result of the SQL. Click Close to close the Execute

SQL statement window and then click Finish.

Chapter 10. DB2 Development Tools 233

Figure 10-10 Executing SQL

10.The SQL Builder view in the Data perspective shows the constructed SQL statement

(Figure 10-11 on page 234), which can be saved and used in our SQL applications. You

can also use the created SQL statement in the query tool, such as DB2 Query

Management Facility (QMF).