When a table is defined, attributes specific to external DBMS table types are held in the @SERVERPARMS TIBCO Object Service Broker control table, which is parameterized by table type. Each occurrence in the table specifies a value for the table with regard to the external environment, such as SERVERID or SERVERTYPE.
At runtime, you can dynamically modify the SERVERID startup parameter using the
SETXPARM and
RESETXPARM shareable tools. This reduces the number of table definitions required to define the external data. The changes are stored in either of two session tables:
This example sets the value of the Optimize Update field for the EMPLOYEE table to Y: