LucidDbSysRoot TEST ALL SERVERS FOR WRAPPER

Syntax

CALL SYS_ROOT.TEST_ALL_SERVERS_FOR_WRAPPER( data_wrapper_name )

Purpose

Tests connections for all data servers associated with a SQL/MED data wrapper. This can be useful as a validation step before starting a complex data extraction process.

Parameters

• data_wrapper_name: [VARCHAR(128)] name of a wrapper previously created with |CREATE FOREIGN WRAPPER

Output

None. If the test succeeds, the procedure returns successfully; otherwise, if a connection failure occurs for any one of the servers, an error is returned with the cause of connection failure. The name of the server which was being tested is available as an additional context entry in the SQLException chain.

Examples

Test all servers based on the SYS_JDBC foreign data wrapper:

CALL SYS_ROOT.TEST_ALL_SERVERS_FOR_WRAPPER('SYS_JDBC');