Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 2 Operating Service Gateway for IDMS/DB : Dynamically Changing the Gateway Parameters

Dynamically Changing the Gateway Parameters
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.
Sample @SERVERPARMS Control Table for Table Type IDM

 
BROWSING TABLE : @SERVERPARMS(IDM)
COMMAND ==>
 
NUMBER NAME TYPE SYNTAX LENGTH DECIMAL DEFAULT
_ ----------- -------------- - - ------ ------- -------------------
_ 1 SERVERID S C 8 0 DEFAULT
_ 2 SERVERTYPE S C 3 0 IDM
_ 3 SUBSCHEMA S C 8 0
_ 4 READY_MODE S C 2 0 SR
_ 5 DBNAME S C 8 0
_ 6 OPTIMIZEUPDATE S C 1 0 N
_ 7 USERSUBSCHEMA S C 8 0
_ 8 CODEPAGE S C 32 0
_ 9 VERSION Q V 8 0 0
 
 
 
 
 
 
 
 
 
 
PFKEYS: 1=HELP 5=FIND NEXT 9=RECALL 18=EXCLUDE 13=PRINT 3=END 14=EXPAND

 
Modifying the SERVERID Startup Parameter
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:
 
The changes are in effect for the duration of the session or until SETXPARM is invoked again or the overrides are reset.
The Gateway Parameters That Can Be Overridden at Runtime
The following table lists the gateway parameters and Table Definer fields that can be dynamically changed with SETXPARM and RESETXPARM:
Parameter or Field
Examples Using SETXPARM and RESETXPARM
The following example sets the SERVERID for all IDM tables to TORONTO:
CALL SETXPARM('TABLETYPE', 'IDM', 'SERVERID', 'TORONTO', '');
This example sets the value of the Optimize Update field for the EMPLOYEE table to Y:
CALL SETXPARM('TABLENAME', 'EMPLOYEE', 'OPTIMIZEUPDATE', 'Y', '');
This example resets the SERVERID for IDM tables to the Table Definer default value.
CALL RESETXPARM ('TABLETYPE', 'IDM', 'SERVERID', '');
See Also
TIBCO Object Service Broker Shareable Tools for detailed descriptions of SETXPARM and RESETXPARM.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved