Predefined Stored Procedures¶
The following subsections describe the stored procedures included out-of-the-box with Virtual DataPort.
- CACHE_CONTENT
- CATALOG_ELEMENTS
- CATALOG_FKS
- CATALOG_METADATA_VIEWS
- CATALOG_PERMISSIONS
- CATALOG_PKS
- CATALOG_VDP_METADATA_VIEWS
- CATALOG_VIEWS
- CLEAN_CACHE_DATABASE
- COLUMN_DEPENDENCIES
- COMPACT_METADATA_TABLES
- DUAL
- GENERATE_SMART_STATS_FOR_FIELDS
- GENERATE_SMART_STATS_FOR_FIELDS_BY_TABLENAME
- GENERATE_STATS
- GENERATE_STATS_FOR_FIELDS
- GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW
- GET_CACHE_COLUMNS
- GET_CACHE_CONFIGURATION
- GET_CACHE_TABLE
- GET_CATALOG_EFFECTIVE_PERMISSIONS
- GET_ELEMENTS
- GET_EXPORTED_KEYS
- GET_FOREIGN_KEYS
- GET_JDBC_DATASOURCE_TABLES
- GET_PRIMARY_KEYS
- GET_PROCEDURE_COLUMNS
- GET_SESSIONS
- GET_SOURCE_COLUMNS
- GET_SOURCE_TABLE
- GET_TYPE_ATTRIBUTES
- GET_USER_DEFINED_TYPES
- GET_VIEW_COLUMNS
- GET_VIEW_INDEXES
- GET_VIEWS
- LIST_JDBC_DATASOURCE_TABLES
- LOGCONTROLLER
- SOURCE_CHANGES
- VIEW_DEPENDENCIES
- WAIT
- WEBCONTAINER_ELEMENTS
- WRITELOGERROR
- WRITELOGINFO
To get the same metadata as with the Denodo JDBC driver, invoke these procedures: GET_ELEMENTS(), GET_EXPORTED_KEYS(), GET_FOREIGN_KEYS(), GET_PRIMARY_KEYS(), GET_PROCEDURE_COLUMNS(), GET_TYPE_ATTRIBUTES(), GET_USER_DEFINED_TYPES(), GET_VIEWS(), GET_VIEW_COLUMNS() and GET_VIEW_INDEXES().