![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
If you are working in a distributed data environment and you are accessing data across nodes, you must establish a relationship with the tables to be used. You establish this relationship through the definitions of the related tables. When this relationship is established, your data can be stored remotely or locally to the definition.To access data that resides on another node, the following conditions for the table definitions must be met:
• The table containing the data must be defined with the same table name and the same location parameter name on both the local and the remote nodes.
• If data is to reside on a particular node, the full definition for the table must exist on that node.
• If data is not to reside on a particular node, only a minimal definition of that table is required at that node. Optionally, you can have a full definition on both nodes if you want.
• If data resides on both a local and remote node, the data on both nodes must be accessible when the data on the remote node is being accessed.The simplest way to relate definitions is to copy a full definition from one node to another. If required, you can modify it to be only a minimal definition by following the tasks below. Because your tables are to be used in a distributed data environment, you must use the shareable copy tools COPY_DEFN and COPYDEFN to copy the definition. These tools are discussed in Copying a Definition and described fully in TIBCO Object Service Broker Shareable Tools.As previously noted, you can use a minimal definition on a node so long as data is not to reside with the definition. A minimal definition consists of:
• The name of the remote node where the full definition is located. This value is determined using the order of evaluation described in Order of Evaluation to Determine Location.If you have already used one of the shareable copy tools, complete the following tasks to create a minimal definition from the full definition. Refer to Definition and Data Requirements for Distributed Data for restrictions on values.
2. Delete the values in all the fields of the table identification portion, leaving only the Table field defined.
3. Using the D line command, delete all the parameters except for the LOCATION parameter, and delete all the fields.The name of the location parameter must be the same as the location parameter for the table with the full definition.If you have not already copied the definition, complete the following tasks to create a minimal definition.
2. Delete the values in all the fields of the table identification portion, leaving only the Table field defined.The name of the location parameter must the same as the location parameter for the table with the full definition.
− Define a subview table with the same name as the remote subview and its source is the minimal definition defined above.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |