LISTTABLES view
The DVSYS.LISTTABLES view contains details about the list of tables 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. |
| TNAME | VARCHAR(128) | The table name. |
| TTYPE | VARCHAR(80) | The table type. |
Example
This example query retrieves the table list under the schema (
schema1) from the
Db2
source.SELECT * FROM DVSYS.LISTTABLES WHERE CID='DB210000' AND
FILTER='null,schema1,null,null'