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


Chapter 3 Tools : BROWSER

BROWSER
Displays the contents of a TIBCO Object Service Broker table for viewing. (CE)
Invocation
Do one of the following:
Type BROWSER(tablespec) <Enter>
Type EX BROWSER(tablespec) <Enter>
Type CALL BROWSER(tablespec)
Where:
 
You should set the BROWSE flag to Y to ensure the data is not locked.
Usage Notes
If you are using BROWSER to browse a table, you cannot edit an occurrence. You can use all the other commands supported within the Browser facility.
STEBROWSE is the interactive version of this tool used on the developer workbench.
See Also
TIBCO Object Service Broker Managing Data for additional information on the Table Browser.
Example
In the following screen, the user can browse a table containing data on the employees of a selected region:

 
Date: 2000-01-11 Employees by Region
_ East
_ Mideast
_ Central
_ Midwest
_ West
FCNKEYS: ENTER=GET EMPLOYEES 12=EXIT

 
Screen Table Definition
The fields of the screen table containing the regions are named to match the parameters of the EMPLOYEES table, which is also parameterized by region:

 
SCREEN PAINTER COMMAND ==> Scroll: P
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....
¬A East
¬A Mideast
¬A Central
¬A Midwest
¬A West
Table: REGIONS Unit: BZDD0
ROW COL FIELD NAME Type Syn Len Dec Just Fill Prot Show Rqd Hi Skip Null
--- --- --------------- - - ---- --- - - - - - - - -
1 2 EAST C 1 0 L _ N Y N N Y Y
2 2 MIDEAST C 1 0 L _ N Y N N Y Y
3 2 CENTRAL C 1 0 L _ N Y N N Y Y
4 2 MIDWEST C 1 0 L _ N Y N N Y Y
5 2 WEST C 1 0 L _ N Y N N Y Y
PFKEYS: 6=+FLD 18=-FLD 4=+LINE 5=CUT 19=FLD_HELP 17=PASTE 16=-LINE 13=PRINT

 
GETREGION Rule
When you press Enter, the following rule returns the name of the field where the cursor is placed and calls BROWSER to display the contents of the table:

 
RULE EDITOR ===> SCROLL: P
GETREGION;
_ LOCAL REG;
_ ---------------------------------------------------------------------------
_ ------------------------------------------------------------+--------------
_ REG = CURSORFIELD('EMPLOYEE_SCR_C'); | 1
_ CALL BROWSER('EMPLOYEES(' || REG ||')'); | 2
_ ---------------------------------------------------------------------------

 
Resulting Output
When you place the cursor beside Midwest and press Enter, the following data appears for browsing:

 
BROWSING TABLE : EMPLOYEES(MIDWEST)
COMMAND ==>
SCROLL: P
EMPNO LNAME POSITION MGR# DEPTNO SALARY
_ ------ ---------------------- -------------- ------ ------ ---------
_ 22001 DRABEK CUST SUPPORT 56112 30 900.00
_ 22007 ROEDER CUST SUPPORT 56112 30 900.00
_ 30058 HOEGSON PRE-SALES 37219 20 675.00
_ 34111 TERAMURA PRE-SALES 37219 20 710.00
_ 34121 LEES CUST SUPPORT 56112 30 700.00
_ 36162 MORANG JR OPERATOR 44798 80 575.00
_ 41001 CROFTON TECH WRITER 80002 70 675.00
_ 41007 STEVENSON EDUCATOR 80002 60 700.00
_ 41009 SMITH TESTER 79912 50 600.00
_ 44385 SOUZA SALES 37219 10 719.00
_ 44622 SAUNDERS ACCOUNTANT 98895 40 800.00
_ 51111 HRODEK ANALYST 79912 50 710.00
_ 51121 CANNON ANALYST 79912 50 700.00
_ 51162 KIMURA JR PROGRAMMER 79912 50 575.00
_ 61219 WONG SENIOR ANALYST 79912 50 820.00
_ 61385 DHILLON EDUCATOR 80002 60 685.00
_ 61622 SCHULTZ SENIOR ANALYST 79912 50 800.00
PFKEYS: 1=HELP 5=FIND NEXT 9=RECALL 18=EXCLUDE 13=PRINT 3=END 14=EXPAND

 

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