LucidDbSysRoot TEST DATA SERVER

Syntax

CALL SYS_ROOT.TEST_DATA_SERVER( data_server_name )

Purpose

Tests a SQL/MED data server to see if a connection can be established. This can be useful as a validation step before starting a complex data extraction process.

Parameters

• data_server_name: [VARCHAR(128)] name of a server previously created with CREATE SERVER

Output

None. If the test succeeds, the procedure returns successfully; otherwise an error is returned with the cause of connection failure.

Examples

CALL SYS_ROOT.TEST_DATA_SERVER('POSTGRES_PSRV');