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 about the external environment, such as SERVERID and DBID.
At runtime, you can dynamically modify the SERVERID gateway startup parameter using the utilities
SETXPARM and
RESETXPARM. 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: