![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
If you need to directly retrieve or update specific IMS data, you should have one TIBCO Object Service Broker IMS table definition for each segment that can be uniquely identified. The illustration below shows a sample IMS database where all segments contain unique sequence keys.To create an IMS table definition for each segment in the illustration above, complete the following steps:
1. Determine the unique sequence key of each segment in the database using the control table @IMSSEGS(dbname).
1. Determine the type of key (unique, multiple, or no key) for each segment of the database using the @IMSSEGS(dbname) control table.
If you plan to modify IMS data using this definition, specify Optimize Update=Y in the IMS Table Definition screen.
If you plan to modify IMS data using this definition, specify Optimize Update=Y in the IMS Table Definition screen.
If you plan to modify IMS data using this definition, specify Optimize Update=Y in the IMS Table Definition screen.
Segment G has a unique sequence key; however, if you plan to modify IMS data using this definition, you must still specify Optimize Update=Y in the IMS Table Definition screen, since its parent (segment E) does not have a unique sequence key.
For definitions containing non-unique IMS segments, the Gateway requires a minimum of two identical PCBs defined for the database in question. Refer to Retrieval Processing for more information.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |