Creating a query condition
The query needs a query condition so that the query extracts only result rows with a given customer social security number. We add conditions to the query by using the Conditions page in the Design pane.
To create a query condition:
| In the Design pane, select the Conditions tab. |
|
| In the first row, click the cell in the Column column and select C.LAST_NAME in the list. |
|
| In the same row, click the cell in the Operator column, and select the LIKE operator. |
|
| In that row, click the cell in the Value column, and enter %u%. |
A colon followed by a variable name is the SQL syntax for a host variable that will be substituted with a value when you run the query.
|
| The Conditions page is shown in Figure | -15. |
Figure 11-15 Create select statement: Conditions
|
ibm.com/redbooks |