LISTSCHEMAS view
The DVSYS.LISTSCHEMAS view contains details about the list of schemas 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.
- The default maximum row as specified in BATCHSIZE_FOR_LISTSCHEMAS_OR_LISTTABLES is 10000.
For more information, see SETCONFIGPROPERTY properties.
| Column | Type | Description |
|---|---|---|
| CID | VARCHAR(20) | The connection identifier of the data source. This is a required input predicate in the form of a string constant. |
| FILTER | VARCHAR(500) | The composite CSV string in the format of
'<CATALOG>,<SCHEMAPATTERN>,<TABLENAMEPATTERN>,<TABLETYPES>'. |
| TCATALOG | VARCHAR(128) | The catalog name. |
| TSCHEM | VARCHAR(128) | The schema name. |
| NUMTABS | BIGINT | The total number of tables under this schema. The values are -1 unless a
comparison predicate is applied against NUMTABS to activate table counting. |
Example
This example query retrieves the schema list from the Db2 source without any filters, and displays the number
of tables in each
schema.
SELECT * FROM DVSYS.LISTSCHEMAS WHERE CID='DB210000' AND FILTER='null,null,null,null' AND
NUMTABS>=-1