LISTSOURCES view
The DVSYS.LISTSOURCES provides the list of available data sources that were discovered and explicitly configured (non-discovered) on the Data Virtualization constellation.
| Column | Type | Description |
|---|---|---|
| DB_HOSTNAME | VARCHAR(2000) |
The hostname/IP of the data source, which might be inaccurate if the connecting node is already running. |
| IS_CONFIGURED | SMALLINT | Lists whether the connection has already been defined. |
| IS_CONNECTED | SMALLINT | Lists whether the connection was successfully established. |
| IS_DISCOVERED | SMALLINT | Lists whether the connection was discovered. |
| NODE_NAME | VARCHAR(80) | Name of the node that found the data source. |
| PORT | INTEGER | The port that the service was discovered upon. |
| SRCTYPE | VARCHAR(20) | Source type of the data source which is identified by the API. |