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


Chapter 9 Using TIBCO Object Service Broker to Process CA Datacom Data : Using the Table Browser

Using the Table Browser
You can use the Table Browser to browse a defined DAT table by typing the table name next to the BR browse table option and using Enter.
In the sample screen below, PERSONNELD is the name of the DAT table. The CA Datacom data is presented to you in TIBCO Object Service Broker table format.

 
BROWSING TABLE : PERSONNELD
COMMAND ==>
SCROLL: P
NUMBER NAME 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

 
Exceptions
You can browse and edit a DAT table in the same way you would browse or edit another table, except:
The Duplicate Master Keys field is set to Y.
You cannot update the table using the Table Editor. You can, however, use the Table Browser and the Single Occurrence Editor.
Your table definition contains fields that are longer than 260 bytes.
You must use SELECT LIKE instead of SELECT to access fields of this length.
Insertion of Duplicate Primary Keys
Depending on its indexes, you can use CA Datacom to insert duplicate primary keys. A duplicate primary key results in the following:
See Also
TIBCO Object Service Broker Managing Data for more information about browsing and editing tables in TIBCO Object Service Broker.

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