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


Chapter 7 Operational Requirements for CA Datacom Access : Dynamically Changing the Parameters

Dynamically Changing the Parameters
You can change the parameters dynamically, as described in this section.
Table Type Attributes
When a table is defined, attributes specific to external DBMS table types are held in the @SERVERPARMS control table, which is parameterized by table name. Regarding the external environment, each occurrence in the table specifies a value (such as SERVERID and SERVERTYPE) for the table.
Following is a sample @SERVERPARMS(PAYROL) control table:

 
TABLE : @SERVERPARMS(PAYROL)
COMMAND ==>
SCROLL:
NUMBER NAME TYPE SYNTAX LENGTH DECIMAL DEFAULT USAGE
_ ----------- ---------------- - - ------ ------ - -
_ 1 SERVERID I C 8 0 . C
_ 2 SERVERTYPE S C 3 0 . T
_ 3 DATACOMNAME S C 3 0 . D
_ 4 DBID Q B 2 0 . I
_ 5 ELMNAME S C         5      0 . E
_ 6 OPTIMIZE L C 1 0 . O
_ 7 LENGTH Q B 2 0 . L
_ 8 NAME S C 32 0 . N
_ 9 VERSION Q V 8 0 . V
_ 10 URTNAME S C 8 0 . U
 
PFKEYS: 1=HELP 5=FIND NEXT 9=RECALL 18=EXCLUDE 13=PRINT 3=END 14=EXPAND

 
Use the SETXPARM and RESETXPARM tools to modify the SERVERID. Modifying this parameter reduces the number of table definitions required to define the external data. The changes are stored in either of the following tables:
 
The changes are in effect for the duration of the session until SETXPARM is invoked again or when the overrides are reset.
Examples Using SETXPARM and RESETXPARM
The following example sets the SERVERID for all DAT tables to TORONTO:
CALL SETXPARM('TABLETYPE', 'DAT', 'SERVERID', 'TORONTO', '');
The following example resets the SERVERID for DAT tables to the Table Definer default value:
CALL RESETXPARM ('TABLETYPE', 'DAT', 'SERVERID', '');
See Also
TIBCO Object Service Broker Shareable Tools for detailed descriptions of the SETXPARM and RESETXPARM tools.

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