USER MANUALS

QUERY WRAPPER Statements

Note

The command “QUERY WRAPPER” is deprecated and it may be removed in future major versions of the Denodo Platform.

The section Features Deprecated in Denodo Platform 8.0 lists all the features that are deprecated.

You should not use this command; it is only kept to be able to query ITPilot wrappers, which are deprecated as well. Instead, you need to create a base view over the wrapper and query the base view with a “SELECT” statement.

Virtual DataPort allows directly querying wrappers (without having to define base relations on them). To do it, use the statement QUERY WRAPPER. You have to provide the type and name of the name and optionally, a list of conditions in the format <value>, binary operator, <value> (see the syntax of condition values in the section Syntax of Functions and Condition Values). Unary operators and multi-valued binary operators are not allowed.

Syntax of the QUERY WRAPPER statement
QUERY WRAPPER { CUSTOM | DF | ESSBASE | ITP | JDBC | JSON | LDAP |
                ODBC | OLAP | SALESFORCE | SAPBWBAPI | SAPERP | WS | XML } <name:identifier>
    [
      ( <value> <binary operator> <value>
     [, <value> <binary operator> <value> ]*
      )
    ]

<value> ::= (see section Syntax Conventions)

See below the syntax to query WWW wrappers. This syntax is slightly different than for the other types of wrappers. Only a list of key = value pairs can be indicated, which will be directly received by the wrapper as input parameters.

Syntax of the QUERY WRAPPER ITP (WWW) statement
QUERY WRAPPER ITP <name:identifier>
[
    (
        <name:identifier> = <value:literal>
        [, <name:identifier> = <value:literal>]*
    )
]

Add feedback