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


Chapter 4 Processing Data : Accessing TIBCO Object Service Broker IDM Tables

Accessing TIBCO Object Service Broker IDM Tables
When you access CA‑IDMS data from TIBCO Object Service Broker, the following occurs:
TIBCO Object Service Broker requests are translated into CA‑IDMS Data Manipulation Language (DML) statements.
You can access the data using either of the following methods:
These methods are discussed in the following sections.
Using the Table Browser
You can use the Table Browser to browse a defined IDM table by typing the table name next to the BR browse table option, for example:
OFFICE_EMP(’002’)<Enter>
In this example, OFFICE_EMP is the name of the IDM table and 002 is the OFFICE_CODE parameter value. The CA‑IDMS data is presented to you in the TIBCO Object Service Broker table format, as shown in the following sample screen:
CA‑IDMS Data Presented in TIBCO Object Service Broker Table Format

 
BROWSING TABLE : OFFICE_EMP(002)
COMMAND ==>
SCROLL: P
EMP_ID EMP_FIRST_NAME EMP_LAST_NAME EMP_STREET EMP_CITY
_ ------ ---------- --------------- -------------------- ---------------
_ 69 JUNE BLOOMER 14 ZITHER TERR LEXINGTON
_ 119 CHARLES BOWER 30 RALPH ST WELLESLEY
_ 81 TOM FITZHUGH 450 THRUWAY ST MANSFIELD
_ 45 GEORGE FONRAD 99 VERDE ST STOUGHTON
_ 53 ROBIN GARDNER 68 75TH ST LOWELL
_ 30 HENRIETTA HENDON 16 HENDON DR WELLESLEY
_ 100 EDWARD HUTTON 781 CROSS ST MELROSE
 _ 51 CYNTHIA JOHNSON 17 MANIFESTO DR WALPOLE
_ 49 DOUGLAS KAHALLY 56 SPELLING AVE READING
_ 67 MARIANNE KIMBALL 561 LEXINGTON AVE LITTLETON
_ 106 DORIS KING 716 MORRIS ST MELROSE
_ 127 CAROL MCDOUGALL 19 URITOP DR WELLESLEY
_ 101 BRIAN NICEMAN 60 FLORENCE AVE MELROSE
_ 91 MADELINE ORGRATZI 67 RAINBOW DR KENDON
_ 149 LAURA PENMAN 45 THRUSH LN WALTHAM
 
 
PFKEYS: 1=HELP 5=FIND NEXT 9=RECALL 18=EXCLUDE 13=PRINT 3=END 14=EXPAND

 
Exceptions
You can browse an IDM table in the same way you would browse any other TIBCO Object Service Broker table, with the following exceptions:
Use the Single Occurrence Editor (SOE) from the Table Editor to view them.
Use SELECT LIKE instead of SELECT to access fields of this length.
If your transaction is running in update mode, the Ready Mode specified in the IDM table definition, not TIBCO Object Service Broker, determines locking of CA‑IDMS data. However, if your transaction is running in browse mode, a shared retrieval (SR) Ready Mode is automatically used, regardless of what is specified in the first IDM table accessed in the transaction. No locks are taken in browse mode and you cannot update the data.
See Also
TIBCO Object Service Broker Managing Data for more information on using the Table Browser.

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