removeRdbcX stored procedure (Variation 1)

Last updated: Mar 17, 2025

removeRdbcX stored procedure in Data Virtualization

Removes a data source connection from one or more endpoint nodes. The schema is DVSYS.

Input parameters

connection_ID: The type of this required parameter is VARCHAR(20). Specifies the connection ID that is to be removed.
node_name: The type of this required parameter is VARCHAR(32672). Specifies the names of the nodes from which the data source will be removed.

Output parameters

number_of_defined_connections: The type of this parameter is INTEGER. Represents the total number of removed connections.
diagnostics: The type of this parameter is VARCHAR(32672). Represents diagnostic output if a failure occurs.

Syntax

Use the following syntax and replace the parameters below for this stored procedure:

call DVSYS.removeRdbcX('<connection_ID>', '<node_name>', ?, ?)

Example

call DVSYS.removeRdbcX('DB210060', 'qpendpoint_2:6416', ?, ?)

Was the topic helpful?

0/1000