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_HADOOP_CACHE
- COMPACT_METADATA_TABLES
- CREATE_REMOTE_TABLE
- DROP_REMOTE_TABLE
- 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_ACTIVE_LOGGERS
- GET_ASSOCIATIONS
- GET_CACHE_COLUMNS
- GET_CACHE_CONFIGURATION
- GET_CACHE_TABLE
- GET_CATALOG_EFFECTIVE_PERMISSIONS
- GET_CATALOG_METADATA_WS
- GET_DELEGATED_SQLSENTENCE
- GET_ELEMENTS
- GET_EXPORTED_KEYS
- GET_FOREIGN_KEYS
- GET_JDBC_DATASOURCE_TABLES
- GET_PRIMARY_KEYS
- GET_PROCEDURE_COLUMNS
- GET_SERVER_CONNECTIVITY
- GET_SESSIONS
- GET_SOURCE_CHANGES
- GET_SOURCE_COLUMNS
- GET_SOURCE_TABLE
- GET_TYPE_ATTRIBUTES
- GET_USER_DEFINED_TYPES
- GET_VIEW_COLUMNS
- GET_VIEW_INDEXES
- GET_VIEW_STATISTICS
- GET_VIEWS
- LIST_JDBC_DATASOURCE_TABLES
- LOGCONTROLLER
- MIGRATE_DATE_TYPES
- PING_DATA_SOURCE
- SOURCE_CHANGES
- VIEW_DEPENDENCIES
- WAIT
- WEBCONTAINER_ELEMENTS
- WEBCONTAINER_ELEMENT_STATUS
- 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().
When invoking these procedures, always filter by their input parameters if possible. The query will finish much faster and will put much less strain on the Denodo server.