WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Specify WHERE Criterion window

Use the Specify WHERE Criterion window to create WHERE clauses for a view based on the selected columns. You can build WHERE clauses for simple views or for views on tables that contain more than one record type. If you are proficient with SQL, you can also modify the view SQL in the property pages after this wizard creates the view.

Column
Select a column to add to the WHERE clause.
Operator
Select an operator.
Value
Provide a value Extended description if needed.

Selecting 88 columns

If you select a column that contains 88 values, the operator changes to = and, in the Value field, you can select the record type that you want to filter on.

If there is more than value for the 88 column, a separate WHERE criterion is created for each value. For example, the following 88 record, when chosen as a column for the WHERE clause, creates to WHERE criteria:
88 MYVALUES VALUE "A","X" THRU "Z","B"

The two WHERE criteria are:

Table 1.
Column Operator Value AND/OR
MYVALUES BETWEEN 'X' AND 'Z' OR
MYVALUES IN ('A','B')  

Individual values will use an IN clause and the range values will be a BETWEEN and an OR

Using the IS NULL and IS NOT NULL operators

When you select IS NULL or IS NOT NULL as the operator, you cannot select a value in the Value field.

Using the BETWEEN and NOT BETWEEN operators

When you select BETWEEN or NOT BETWEEN as the operator, you can specify the minimum and maximum values for the range.

Using the IN and NOT IN operators

When you select IN or NOT IN as the operator, you can provide a list of values.



Feedback

Update icon Last updated: 2006-12-15