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.
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.
QUERY WRAPPER ITP <name:identifier>
[
(
<name:identifier> = <value:literal>
[, <name:identifier> = <value:literal>]*
)
]