depend connection

Shows a list compareset names and a list of schema job comparisons that depend on the named connection. The list also indicates whether it is the source or target database using the named connection.

Syntax

depend connection connection_name

Parameters

connection_name – the name of the connection.

Examples

Example 1 – shows compareset dependency for “MyConnPDB”:

depend connection MyConnPDB
go

The returned result is:

COMPARESET      TYPE 
----------      ---- 
compareset1     S   
compareset2     T   

SCHEMA JOB   COMPARISON    TYPE 
-----------  ----------    ---- 
schema_job2   comparison2  S   
schema_job3   comparison2  T