Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 5 The Action Statements : WHERE Clause

WHERE Clause
The WHERE clause is used to select:
You can use it in conjunction with the ORDERED clause.
Usage Notes
You can select the occurrences of a field that match a pattern using the pattern match operator LIKE. The pattern can contain question marks (?) representing one character of any kind, asterisks (*) representing zero or more unspecified characters, and any other character that must be present in the field.
You can use comparisons with relational and logical operators joined together by the AND (&) or OR (|) operators. The operators are listed in Chapter 3, Supported Characters. The number of conditions that you can code in a WHERE clause is dependent on a number of factors. For example:
Examples
1.
GET EMPLOYEES WHERE REGION ='MIDWEST' & ¬
(STATE_PROV='ONT'| STATE_PROV='MINN');
2.
3.
4.
About the Examples
Example 1 gets the first occurrence from the EMPLOYEES table where the parameter equals MIDWEST and the STATE_PROV field does not equal ONT or MINN.
Example 2 shows how you can also specify selection criteria for a DELETE statement. The selection criteria must consist of an equality between a value and the primary key. In the example, MANAGER_NUM is the primary key for the MANAGER table.
Example 3 shows how you can use the WHERE clause with any of the table access statements to select table instances. In the example, REGION is the parameter name and MIDWEST is the parameter value.
Example 4 shows how you can use the asterisk (*) symbol to retrieve an occurrence that has the same value in two fields of the same table.
See Also
TIBCO Object Service Broker Managing Data about TIBCO Object Service Broker tables.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved