Predefined Stored Procedures

The following subsections describe the stored procedures included out-of-the-box with Virtual DataPort.

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.