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


Chapter 3 Tools : SOE

SOE
Edits a single occurrence in a table. (CE)
Invocation
Do one of the following:
Type SOE(tablespec) <Enter>
Type EX SOE(tablespec) <Enter>
Type CALL SOE(tablespec)
Where:
 
Usage Notes
If you do not supply a value for tablespec, pressing Enter displays a screen prompting for a value.
See Also
Chapter 2, Using User Exits in Workbench Tools about using user exits with the Single Occurrence Editor
TIBCO Object Service Broker Managing Data for information about the Single Occurrence Editor.
Example
To edit the record for employee number 61219 in the EMPLOYEES(MIDWEST) table, type the following at the COMMAND line:
EX SOE(EMPLOYEES)
The following prompt screen appears:

 
--- SINGLE OCCURRENCE EDITOR ---
EDITING TABLE : EMPLOYEES
TABLE TYPE : TDS
------------------------------------------------------------------------------
ENTER PARM VALUE REGION :
ENTER KEY VALUE EMPNO :
 
 
 
 
 
 
 
 
PFKEYS: 1=HELP 3=EXIT 12=EXIT

 
Editing Screen
After supplying the value MIDWEST for REGION and 61219 for EMPNO, the following editing screen appears:

 
--- SINGLE OCCURRENCE EDITOR ---
EDITING TABLE : EMPLOYEES(MIDWEST)
TABLE TYPE : TDS
COMMAND ==>
------------------------------------------------------------------------------
EMPNO : 61219
LNAME : WONG
POSITION : SENIOR ANALYST
MGR# : 79912
DEPTNO : 50
SALARY : 820.00
ADDRESS : 567 Pine St.
CITY : MISSISSAUGA
STATE_PROV :
ZP_CODE :
HIREDATE : 1997-12-03
PFKEYS: 1=HELP 2=DOCUMENTATION 3=SAVE 12=CANCEL 13=PRINT 22=DELETE

 

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