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


Appendix A Common TIBCO Object Service Broker Text-Based Workbench Functionality : Common TIBCO Object Service Broker PF Keys : Available Operators

Available Operators
 
Operators are used in conjunction with primary commands to narrow the scope of the command. The following operators are available:
Multiple Conditions with AND
You can connect several conditions in a command using the operator AND (or the symbol &). AND means that the conditions before and after the AND are both included in the search criteria.
Example
Type find manager='simons' and deptno=10 to locate those employees whose manager is Simons and who work in department 10.
Multiple Conditions with OR
You can use the operator OR (or abbreviation |) to connect several conditions. OR means that condition one is true, condition two is true, or both conditions are true.
Example
Type select manager='simons' or deptno=10 to select those employees, regardless of their department, whose manager is Simons, and all those employees who work in department 10.
Those employees who have Simons as a manager and are in department 10 are selected only once.
Comparisons with Relational Operators
You can compare two values using the following operators:
Example
Here are some examples of conditions:
Type find deptno=30 to locate employees who are in department 30.
Type find position¬='sales' to locate all employees who are not in sales.
Type find salary>=986.73 to locate all salaries that are greater than or equal to $986.73.
Partial Matches with LIKE
You can use LIKE to perform partial matches when using SELECT or FIND. The string that you use must be enclosed in single quotation marks.
You can use the following wildcard characters in conjunction with LIKE:
Example
The following are some examples of inquiries that use LIKE and wildcards in a FIND command. In these examples, only the first employee is found. To find more employees, use the Find Next PF key (PF5) or use a SELECT to find all employees that match the selection criteria:
Type find lname like 'C*' to locate the first employee whose last name begins with C, regardless of how many characters follow the C.
Type find lname like '????G' to locate the first employee whose last name is five characters long and ends in G.
Type find lname like '?H*LD' to locate the first employee whose last name has H as the second character and LD as the last two characters.
Type find deptno=50 and lname like '?I*' to locate the first employee of department 50 whose last name has I as the second character.

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