To modify the list of objects on the Object Manager screen, for example by selecting only certain members or by changing the order of presentation, or to act upon a subset of it, you can use the following four primary commands:
A history of ten previous commands is available from the Object Manager screens of the TIBCO Object Service Broker workbench tools. Press PF9 up to a maximum of ten times until you reach the previous primary command that you require. This limit is available for each tool and lasts for the duration of your TIBCO Object Service Broker session.
The FIND command locates an occurrence that meets the selection criteria you specify The search starts at the cursor position, not at the beginning of the selection. If an occurrence that meets the condition is found, the cursor is placed to the left of its primary key, which is highlighted. To find a subsequent occurrence that meets the same criteria, press PF5 (
FIND NEXT).
The SELECT command locates and displays a subset of occurrences of a table that meet the selection criteria. After you issue a
SELECT, you can view all the occurrences in the table again by issuing the
SELECT command with no selection criteria.
The occurrences in a table are stored in ascending order by primary key. However, you can display the information in descending order. If you want to order by a certain field, type the
ORDERED command and then the field name on the command line. You can also specify multiple levels of ordering in one command. When specifying ascending or descending order, you can use the short forms, Asc or Desc.
You can combine the SELECT and
ORDERED commands to display selected occurrences in a specified order. The results of a
SELECT...ORDERED command are not stored in memory. A subsequent
SELECT...ORDERED command affects the entire set of occurrences, not just the occurrences included in the most recent
SELECT...ORDERED.
Type select deptno=10 ordered lname to select all the employees in department 10, ordered according to last name.
You can use APPLY to execute a line command for a set of occurrences using APPLY. The executed line command is applied to the selected items when you press Enter. You can use this command in conjunction with WHERE and
ORDERED. For more information on line commands, refer to
Managing MetaStor Objects.
Type apply p where creator='USR40' ordered desc name to print all the tables created by user ID USR40 in descending order by name.