GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW

Description

The stored procedure GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW returns the VQL statements necessary to create a JDBC base view for a given table of the underlying database of a JDBC data source. Note that it does not actually creates the view, only returns the VQL statements to do so.

Syntax

GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW (
      data_source_name : text
    , catalog_name : text
    , schema_name : text
    , table_name : text
    , base_view_name : text
    , folder : text
    , i18n : text
)
  • data_source_name: name of the data source.
  • catalog_name: name of the catalog that contains the table over which to create the base view. Set to null if the database does not support catalogs.
  • schema_name: name of the schema that contains the table over which to create the base view. Set to null if the database does not support schemas.
  • table_name: name of the table in the database over which to create the base view.
  • base_view_name: name of the base view to be created. If null, the procedure auto-generates a name for the base view and its JDBC wrapper and ensures that, at the moment of executing this procedure, there is not another JDBC wrapper nor view with the same name.
  • folder: name of the folder in which to place the created base view. The result will include a VQL statement to create the folder. If null, the parameter FOLDER will not be present in the statement CREATE TABLE nor the statements to create a folder.
  • i18n: I18N of the base view to be created. If null, the parameter I18N of the base view will be the i18n the Server.

The procedure returns one row for each VQL statement necessary to create the base view:

  • creation_vql: statements necessary to create the desired base view.

The procedure returns an error if the schema, catalog or table do not exist in the database.

Privileges Required

The user must have execute privileges over the data source.