Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 3 Tools : STE
STE
Invokes the Table Editor. (CE)
Invocation
Do one of the following:
From the…
Move the cursor to the…
And…
Developer’s workbench
ED edit table option
Type tablename <Enter>
EX Execute Rule option
Type STE(tablename) <Enter>
COMMAND prompt
Type ED tablename) <Enter>
From a rule
 
Type CALL STE(tablename)
Where:
 
tablename
The name of the source table and any parameters.
Usage Notes
•
If the table is parameterized and you do not supply any parameter values, executing STE displays a prompt for the parameter values.
•
If you supply a value for tablename, executing STE displays a screen that you use to edit the table.
•
If you do not supply a value for tablename when you use the ED edit table option or the command line, executing STE displays the list of tables defined in your TIBCO Object Service Broker database. Select the table that you require from this list.
•
If you do not supply a value for tablename when you use the EX execute rule option, pressing Enter displays a screen prompting for a table name.
•
The default search path for event rules varies depending on how you invoke STE. When executed from within a rule or from the EX execute rule option, STE searches your local library for any event rules that can be specified. When invoked through the ED edit table option or at the command prompt through the ED command, the default TIBCO Object Service Broker installation specifies that STE searches your system library for the event rule. You can therefore use STE to verify if a new or newly modified event rule is functioning.
See Also
•
Chapter 2, Using User Exits in Workbench Tools about using user exits with the Table Editor
•
TIBCO Object Service Broker Managing Data for information about the Table Editor.
Example
From the following screen, the user can browse or edit a table containing data on the employees of a selected region:
 
Date: 2000-04-11 Employees by Region
_ East
_ Mideast
_ Central
_ Midwest
_ West
 
 
 
 
 
 
 
 
 
 
 
 
 
 
FCNKEYS: 2=GET EMPLOYEES 4=EDIT INFORMATION 12=EXIT
 
EMPLOYEES Table
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: USR40
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
 
EDITREGION Rule
When you press PF4, the following rule returns the name of the field where the cursor is placed and calls STE to display the contents of the table for editing:
 
RULE EDITOR ===> SCROLL: P
EDITREGION;
_ LOCAL REG;
_ ---------------------------------------------------------------------------
_ ------------------------------------------------------------+--------------
_ REG = CURSORFIELD('EMPLOYEE_SCR_C'); | 1
_ CALL STE('EMPLOYEES(' || REG ||')'); | 2
_ ---------------------------------------------------------------------------
 
Data for Editing
When you place the cursor beside Midwest and press PF4, the following data appears for editing:
 
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
At TOP
 
Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved