Accessing Table Data

You access data through TIBCO Object Service Broker tools, programs that are written in the TIBCO Object Service Broker rules language, and programs that are external to TIBCO Object Service Broker. Language accesses to your external and TIBCO Object Service Broker data are specified using a table.field construction. You can use the same methods to access external and TIBCO Object Service Broker data.

Requirements before Accessing Data

Before you can access data, you must meet the following requirements:

You must have a table defined for the data.

You must have security access to the table definition and data.

The table must be loaded with data.

If the table is located on a remote node, the server that accesses the remote data must be connected to your local node. You must have definition and data access to the table at the remote node.

If the table is an external table, the server accessing the external data must be running. You must have external security access to the external data.

Locating the Data

The location of the data used by an application is provided through a value for a location parameter. If a location parameter is not defined to the table, the data is retrieved from the local data store.

The value used to determine location is the node name for the TIBCO Object Service Broker system where the required data resides. At installation time, a TIBCO Object Service Broker system is assigned a node name using the Data Object Broker parameter NODENAME.


	You can load and unload definitions of all table types using the LOAD and UNLOAD tools. Only TDS, EES and SES table data can be loaded using these tools.

Order of Evaluation to Determine Location

When data is accessed by a rule, the location of the data is determined by a defined order of evaluation. The evaluation is based on a parameter defined as CLASS=L (location) in the table definition. This evaluation continues until either a non-null location value is found or the end of the list is reached, as shown in the following illustration.

See Also

This manual describes how to define, load, and manipulate data for TIBCO Object Service Broker tables. For additional information on how to access data for presentation and processing and on how to access remote and external data, refer to the following manuals:


Topic	Manual
Processing data	TIBCO Object Service Broker Programming in Rules and TIBCO Object Service Broker Shareable Tools.
Presenting data	TIBCO Object Service Broker Defining Screens and Menus and TIBCO Object Service Broker Defining Reports.
Setting up security	TIBCO Object Service Broker Managing Security
Starting a server for a remote node	Installing and Operating for your operating environment.
Accessing external data	TIBCO Service Gateway for Files Installing and Operating and the external TIBCO Service Gateway manuals for the various supported external data types.
LOAD and UNLOAD tools	TIBCO Object Service Broker Shareable Tools