Docs
...
SETCONFIGPROPERTY stored procedure

SETCONFIGPROPERTY stored procedure

Last updated: Mar 17, 2025
SETCONFIGPROPERTY stored procedure in Data Virtualization

Set or change configuration properties on one or more endpoint services. The schema is DVSYS.

Input parameters

PROPERTY
The type of this required parameter is VARCHAR(2000). Specifies the property name.
VALUE
The type of this required parameter is VARCHAR(32672). Specifies the value for the property.
REMOTENODES
The type of this required parameter is VARCHAR(32672). Specifies the endpoints to apply the property to.

Output parameters

NUMNODESUPDATED
The type of this parameter is INTEGER. Represents the number of nodes updated.
DIAGS
The type of this parameter is VARCHAR(32672). Represents the diagnostic output if a failure occurs.

Syntax

Use the following syntax and replace the following parameters for this stored procedure:
CALL DVSYS.SETCONFIGPROPERTY('<PROPERTY>', '<VALUE>', '<REMOTENODES>', ?);