LISTCATALOGS view

The DVSYS.LISTCATALOGS view contains details about the list of catalogs in an RDBMS source.

  • The default timeout in SOURCE_CATALOG_API_FOREGROUND_TIMEOUT_MS is 30 seconds.
  • The default maximum number of concurrent calls as specified in SOURCE_CATALOG_API_MAX_CONCURRENCY is 4.

    For more information, see SETCONFIGPROPERTY properties.

Table 1. DVSYS.LISTCATALOGS
Column Type Description
CID VARCHAR(20) The connection identifier. This is a required input predicate in the form of a string constant.
TCATALOG VARCHAR(128) The catalog name.

Example

SELECT * FROM DVSYS.LISTCATALOGS WHERE CID='PREST10000'