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


Chapter 3 Tools : SETXPARM

SETXPARM
Overrides a server parameter or the Table Definer default value for a field at table access time. (C)
Invocation
CALL SETXPARM(component, entity, parm name, value, location)
 
TABLETYPE – Indicates that the override value specified is used for all tables of this type.
TABLENAME – Indicates that the override value applies only to this table name.
A valid parameter name as defined in @@SERVERPARMS(tabletype) and listed in Server Parameters and Fields below, or a valid field name defined in the Table Definer and listed in Server Parameters and Fields below.
Usage Notes
Server Parameters and Fields
These are the server parameters or field values that you can override at runtime:
Table Type
Parameter or Field
Maximum Value Length
Example
This example sets SERVERID for all IDM (IDMS/DB) tables to TORONTO for the user’s session, until the next SETXPARM or the resetting of the overrides:
CALL SETXPARM('TABLETYPE', 'IDM', 'SERVERID', 'TORONTO', '');
CALL SETXPARM('TABLENAME', 'EMPLOYEE', 'OPTIMIZEUPDATE', 'Y', '');

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