com.metamatrix.query.optimizer.capabilities
Enum SourceCapabilities.Capability

java.lang.Object
  java.lang.Enum<SourceCapabilities.Capability>
      com.metamatrix.query.optimizer.capabilities.SourceCapabilities.Capability

All Implemented Interfaces:

java.io.Serializable, java.lang.Comparable<SourceCapabilities.Capability>

Enclosing interface:

SourceCapabilities

public static enum SourceCapabilities.Capability
extends java.lang.Enum<SourceCapabilities.Capability>

Enum Constant Summary

BATCHED_UPDATES
Support indicates connector can accept queries with searched CASE WHEN ...

BULK_INSERT
Support indicates connector can accept queries with searched CASE WHEN ...

CONNECTOR_ID
The connector ID, which is used by the optimizer to determine when two models are bound to the same connector

FUNCTION
Support indicates connector allows functions in expressions

MAX_IN_CRITERIA_SIZE
The Maximum number of values allowed in an IN criteria (Integer)

MAX_QUERY_FROM_GROUPS
Max number of groups appearing in a from clause

PREPARED_BATCH_UPDATE
Support indicates connector support prepared statement batch update

QUERY_AGGREGATES
Support indicates connector accepts GROUP BY and HAVING clauses

QUERY_AGGREGATES_AVG
Support indicates connector can accept the AVG aggregate function

QUERY_AGGREGATES_COUNT
Support indicates connector can accept the COUNT aggregate function

QUERY_AGGREGATES_COUNT_STAR
Support indicates connector can accept the COUNT(*) aggregate function

QUERY_AGGREGATES_DISTINCT
Support indicates connector can accept DISTINCT within aggregate functions

QUERY_AGGREGATES_MAX
Support indicates connector can accept the MAX aggregate function

QUERY_AGGREGATES_MIN
Support indicates connector can accept the MIN aggregate function

QUERY_AGGREGATES_SUM
Support indicates connector can accept the SUM aggregate function

QUERY_CASE
Support indicates connector can accept queries with non-searched CASE WHEN ...

QUERY_EXCEPT
Support indicates connector can accept EXCEPT

QUERY_FROM_ANSI_JOIN
Indicates that the source prefers ANSI style joins

QUERY_FROM_GROUP_ALIAS
Support indicates connector can accept joins where groups have aliases (required for QUERY_FROM_JOIN_SELFJOIN)

QUERY_FROM_INLINE_VIEWS
Support indicates connector can push down inline views

QUERY_FROM_INLINE_VIEWS_ORDER_BY
Support indicates connector can push down an ORDER BY in inline views

QUERY_FROM_JOIN
Support indicates connector can accept joins

QUERY_FROM_JOIN_OUTER
Support indicates connector can accept right or left outer joins

QUERY_FROM_JOIN_OUTER_FULL
Support indicates connector can accept full outer joins

QUERY_FROM_JOIN_SELFJOIN
Support indicates connector can accept self-joins where a group is joined to itself with aliases

QUERY_FUNCTIONS_IN_GROUP_BY
Support indicates connector can accept GROUP BY with functions in it.

QUERY_INTERSECT
Support indicates connector can accept INTERSECT

QUERY_ORDERBY
Support indicates connector accepts ORDER BY clause

QUERY_SEARCHED_CASE
Support indicates connector can accept queries with searched CASE WHEN ...

QUERY_SELECT_DISTINCT
Support indicates connector can accept queries with SELECT DISTINCT

QUERY_SELECT_LITERALS
Support indicates connector can accept queries with literals in the SELECT

QUERY_SET_ORDER_BY
Support indicates connector can accept SET QUERY with an ORDER BY clause

QUERY_SUBQUERIES_CORRELATED
Support indicates connector can accept correalted subqueries wherever subqueries are accepted

QUERY_SUBQUERIES_SCALAR
Support indicates connector can accept scalar subqueries in the SELECT, WHERE, and HAVING clauses

QUERY_UNION
Support indicates connector can accept UNION and UNION ALL

QUERY_WHERE
Support indicates connector can accept a WHERE criteria on queries

QUERY_WHERE_AND
Support indicates connector accepts logical criteria connected by AND

QUERY_WHERE_BETWEEN
Support indicates connector accepts criteria of form (element BETWEEN constant AND constant)

QUERY_WHERE_COMPARE
Support indicates connector accepts criteria of form (element operator constant)

QUERY_WHERE_COMPARE_EQ
Support indicates connector accepts criteria of form (element,

QUERY_WHERE_COMPARE_GE
Support indicates connector accepts criteria of form (element >= constant)

QUERY_WHERE_COMPARE_GT
Support indicates connector accepts criteria of form (element > constant)

QUERY_WHERE_COMPARE_LE
Support indicates connector accepts criteria of form (element <= constant)

QUERY_WHERE_COMPARE_LT
Support indicates connector accepts criteria of form (element < constant)

QUERY_WHERE_COMPARE_NE
Support indicates connector accepts criteria of form (element <> constant)

QUERY_WHERE_EXISTS
Support indicates connector accepts the EXISTS criteria

QUERY_WHERE_IN
Support indicates connector accepts criteria of form (element IN set)

QUERY_WHERE_IN_SUBQUERY
Support indicates connector accepts IN criteria with a subquery on the right side

QUERY_WHERE_ISNULL
Support indicates connector accepts criteria of form (element IS NULL)

QUERY_WHERE_LIKE
Support indicates connector accepts criteria of form (element LIKE constant)

QUERY_WHERE_LIKE_ESCAPE
Support indicates connector accepts criteria of form (element LIKE constant ESCAPE char) - CURRENTLY NOT USED

QUERY_WHERE_NOT
Support indicates connector accepts logical criteria NOT

QUERY_WHERE_OR
Support indicates connector accepts logical criteria connected by OR

QUERY_WHERE_QUANTIFIED_ALL
Support indicates connector accepts the quantified comparison criteria that use ALL

QUERY_WHERE_QUANTIFIED_COMPARISON
Support indicates connector accepts quantified subquery comparison criteria

QUERY_WHERE_QUANTIFIED_SOME
Support indicates connector accepts the quantified comparison criteria that use SOME

REQUIRES_CRITERIA

ROW_LIMIT
Support indicates connector can limit result rows

ROW_OFFSET
Support indicates connector support a SQL clause whose output rows offset from the query's result rows (similar to LIMIT with offset)

TRANSACTIONS_XA

Method Summary

static SourceCapabilities.Capability	valueOf(java.lang.String name) Returns the enum constant of this type with the specified name.
static SourceCapabilities.Capability[]	values() Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

QUERY_SELECT_DISTINCT

public static final SourceCapabilities.Capability QUERY_SELECT_DISTINCT

Support indicates connector can accept queries with SELECT DISTINCT

QUERY_SELECT_LITERALS

public static final SourceCapabilities.Capability QUERY_SELECT_LITERALS

Support indicates connector can accept queries with literals in the SELECT

QUERY_FROM_GROUP_ALIAS

public static final SourceCapabilities.Capability QUERY_FROM_GROUP_ALIAS

Support indicates connector can accept joins where groups have aliases (required for QUERY_FROM_JOIN_SELFJOIN)

Since:

3.1 SP2

MAX_QUERY_FROM_GROUPS

public static final SourceCapabilities.Capability MAX_QUERY_FROM_GROUPS

Max number of groups appearing in a from clause

QUERY_FROM_JOIN

public static final SourceCapabilities.Capability QUERY_FROM_JOIN

Support indicates connector can accept joins

Since:

3.1 SP2

QUERY_FROM_ANSI_JOIN

public static final SourceCapabilities.Capability QUERY_FROM_ANSI_JOIN

Indicates that the source prefers ANSI style joins

Since:

6.0.0

QUERY_FROM_JOIN_SELFJOIN

public static final SourceCapabilities.Capability QUERY_FROM_JOIN_SELFJOIN

Support indicates connector can accept self-joins where a group is joined to itself with aliases

Since:

3.1 SP2

QUERY_FROM_JOIN_OUTER

public static final SourceCapabilities.Capability QUERY_FROM_JOIN_OUTER

Support indicates connector can accept right or left outer joins

Since:

3.1 SP2

QUERY_FROM_INLINE_VIEWS

public static final SourceCapabilities.Capability QUERY_FROM_INLINE_VIEWS

Support indicates connector can push down inline views

Since:

4.1

QUERY_FROM_INLINE_VIEWS_ORDER_BY

public static final SourceCapabilities.Capability QUERY_FROM_INLINE_VIEWS_ORDER_BY

Support indicates connector can push down an ORDER BY in inline views

Since:

5.0 SP1

QUERY_FROM_JOIN_OUTER_FULL

public static final SourceCapabilities.Capability QUERY_FROM_JOIN_OUTER_FULL

Support indicates connector can accept full outer joins

Since:

3.1 SP2

QUERY_WHERE

public static final SourceCapabilities.Capability QUERY_WHERE

Support indicates connector can accept a WHERE criteria on queries

Since:

3.1 SP2

QUERY_WHERE_BETWEEN

public static final SourceCapabilities.Capability QUERY_WHERE_BETWEEN

Support indicates connector accepts criteria of form (element BETWEEN constant AND constant)

Since:

4.0

QUERY_WHERE_COMPARE

public static final SourceCapabilities.Capability QUERY_WHERE_COMPARE

Support indicates connector accepts criteria of form (element operator constant)

Since:

3.1 SP2

QUERY_WHERE_COMPARE_EQ

public static final SourceCapabilities.Capability QUERY_WHERE_COMPARE_EQ

Support indicates connector accepts criteria of form (element,

Since:

3.1 SP2

QUERY_WHERE_COMPARE_NE

public static final SourceCapabilities.Capability QUERY_WHERE_COMPARE_NE

Support indicates connector accepts criteria of form (element <> constant)

Since:

3.1 SP2

QUERY_WHERE_COMPARE_LT

public static final SourceCapabilities.Capability QUERY_WHERE_COMPARE_LT

Support indicates connector accepts criteria of form (element < constant)

Since:

3.1 SP2

QUERY_WHERE_COMPARE_LE

public static final SourceCapabilities.Capability QUERY_WHERE_COMPARE_LE

Support indicates connector accepts criteria of form (element <= constant)

Since:

3.1 SP2

QUERY_WHERE_COMPARE_GT

public static final SourceCapabilities.Capability QUERY_WHERE_COMPARE_GT

Support indicates connector accepts criteria of form (element > constant)

Since:

3.1 SP2

QUERY_WHERE_COMPARE_GE

public static final SourceCapabilities.Capability QUERY_WHERE_COMPARE_GE

Support indicates connector accepts criteria of form (element >= constant)

Since:

3.1 SP2

QUERY_WHERE_LIKE

public static final SourceCapabilities.Capability QUERY_WHERE_LIKE

Support indicates connector accepts criteria of form (element LIKE constant)

Since:

3.1 SP2

QUERY_WHERE_LIKE_ESCAPE

public static final SourceCapabilities.Capability QUERY_WHERE_LIKE_ESCAPE

Support indicates connector accepts criteria of form (element LIKE constant ESCAPE char) - CURRENTLY NOT USED

Since:

3.1 SP2

QUERY_WHERE_IN

public static final SourceCapabilities.Capability QUERY_WHERE_IN

Support indicates connector accepts criteria of form (element IN set)

Since:

3.1 SP2

QUERY_WHERE_IN_SUBQUERY

public static final SourceCapabilities.Capability QUERY_WHERE_IN_SUBQUERY

Support indicates connector accepts IN criteria with a subquery on the right side

Since:

4.0

QUERY_WHERE_ISNULL

public static final SourceCapabilities.Capability QUERY_WHERE_ISNULL

Support indicates connector accepts criteria of form (element IS NULL)

Since:

3.1 SP2

QUERY_WHERE_AND

public static final SourceCapabilities.Capability QUERY_WHERE_AND

Support indicates connector accepts logical criteria connected by AND

Since:

3.1 SP2

QUERY_WHERE_OR

public static final SourceCapabilities.Capability QUERY_WHERE_OR

Support indicates connector accepts logical criteria connected by OR

Since:

3.1 SP2

QUERY_WHERE_NOT

public static final SourceCapabilities.Capability QUERY_WHERE_NOT

Support indicates connector accepts logical criteria NOT

Since:

3.1 SP2

QUERY_WHERE_EXISTS

public static final SourceCapabilities.Capability QUERY_WHERE_EXISTS

Support indicates connector accepts the EXISTS criteria

Since:

4.0

QUERY_WHERE_QUANTIFIED_COMPARISON

public static final SourceCapabilities.Capability QUERY_WHERE_QUANTIFIED_COMPARISON

Support indicates connector accepts quantified subquery comparison criteria

Since:

4.0

QUERY_WHERE_QUANTIFIED_SOME

public static final SourceCapabilities.Capability QUERY_WHERE_QUANTIFIED_SOME

Support indicates connector accepts the quantified comparison criteria that use SOME

Since:

4.0

QUERY_WHERE_QUANTIFIED_ALL

public static final SourceCapabilities.Capability QUERY_WHERE_QUANTIFIED_ALL

Support indicates connector accepts the quantified comparison criteria that use ALL

Since:

4.0

QUERY_ORDERBY

public static final SourceCapabilities.Capability QUERY_ORDERBY

Support indicates connector accepts ORDER BY clause

Since:

3.1 SP2

QUERY_AGGREGATES

public static final SourceCapabilities.Capability QUERY_AGGREGATES

Support indicates connector accepts GROUP BY and HAVING clauses

Since:

3.1 SP2

QUERY_AGGREGATES_SUM

public static final SourceCapabilities.Capability QUERY_AGGREGATES_SUM

Support indicates connector can accept the SUM aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_AVG

public static final SourceCapabilities.Capability QUERY_AGGREGATES_AVG

Support indicates connector can accept the AVG aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_MIN

public static final SourceCapabilities.Capability QUERY_AGGREGATES_MIN

Support indicates connector can accept the MIN aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_MAX

public static final SourceCapabilities.Capability QUERY_AGGREGATES_MAX

Support indicates connector can accept the MAX aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_COUNT

public static final SourceCapabilities.Capability QUERY_AGGREGATES_COUNT

Support indicates connector can accept the COUNT aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_COUNT_STAR

public static final SourceCapabilities.Capability QUERY_AGGREGATES_COUNT_STAR

Support indicates connector can accept the COUNT(*) aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_DISTINCT

public static final SourceCapabilities.Capability QUERY_AGGREGATES_DISTINCT

Support indicates connector can accept DISTINCT within aggregate functions

Since:

3.1 SP2

QUERY_SUBQUERIES_SCALAR

public static final SourceCapabilities.Capability QUERY_SUBQUERIES_SCALAR

Support indicates connector can accept scalar subqueries in the SELECT, WHERE, and HAVING clauses

Since:

4.0

QUERY_SUBQUERIES_CORRELATED

public static final SourceCapabilities.Capability QUERY_SUBQUERIES_CORRELATED

Support indicates connector can accept correalted subqueries wherever subqueries are accepted

Since:

4.0

QUERY_CASE

public static final SourceCapabilities.Capability QUERY_CASE

Support indicates connector can accept queries with non-searched CASE WHEN ... END

Since:

4.0

QUERY_SEARCHED_CASE

public static final SourceCapabilities.Capability QUERY_SEARCHED_CASE

Support indicates connector can accept queries with searched CASE WHEN ... END

Since:

4.0

QUERY_UNION

public static final SourceCapabilities.Capability QUERY_UNION

Support indicates connector can accept UNION and UNION ALL

Since:

4.2

QUERY_INTERSECT

public static final SourceCapabilities.Capability QUERY_INTERSECT

Support indicates connector can accept INTERSECT

Since:

5.6

QUERY_EXCEPT

public static final SourceCapabilities.Capability QUERY_EXCEPT

Support indicates connector can accept EXCEPT

Since:

5.6

QUERY_SET_ORDER_BY

public static final SourceCapabilities.Capability QUERY_SET_ORDER_BY

Support indicates connector can accept SET QUERY with an ORDER BY clause

Since:

4.2

QUERY_FUNCTIONS_IN_GROUP_BY

public static final SourceCapabilities.Capability QUERY_FUNCTIONS_IN_GROUP_BY

Support indicates connector can accept GROUP BY with functions in it.

Since:

5.0

BATCHED_UPDATES

public static final SourceCapabilities.Capability BATCHED_UPDATES

Support indicates connector can accept queries with searched CASE WHEN ... END

Since:

4.2

BULK_INSERT

public static final SourceCapabilities.Capability BULK_INSERT

Support indicates connector can accept queries with searched CASE WHEN ... END

Since:

4.2

ROW_LIMIT

public static final SourceCapabilities.Capability ROW_LIMIT

Support indicates connector can limit result rows

Since:

5.0 SP1

ROW_OFFSET

public static final SourceCapabilities.Capability ROW_OFFSET

Support indicates connector support a SQL clause whose output rows offset from the query's result rows (similar to LIMIT with offset)

Since:

5.0 SP1

FUNCTION

public static final SourceCapabilities.Capability FUNCTION

Support indicates connector allows functions in expressions

Since:

3.1 SP2

MAX_IN_CRITERIA_SIZE

public static final SourceCapabilities.Capability MAX_IN_CRITERIA_SIZE

The Maximum number of values allowed in an IN criteria (Integer)

Since:

4.4

CONNECTOR_ID

public static final SourceCapabilities.Capability CONNECTOR_ID

The connector ID, which is used by the optimizer to determine when two models are bound to the same connector

Since:

5.0.2

PREPARED_BATCH_UPDATE

public static final SourceCapabilities.Capability PREPARED_BATCH_UPDATE

Support indicates connector support prepared statement batch update

Since:

5.5.2

TRANSACTIONS_XA

public static final SourceCapabilities.Capability TRANSACTIONS_XA

Since:

6.0.0 indicates the source supports XA transactions

REQUIRES_CRITERIA

public static final SourceCapabilities.Capability REQUIRES_CRITERIA

Since:

6.0.0 indicates support for where all

Method Detail

values

public static SourceCapabilities.Capability[] values()

Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:

for (SourceCapabilities.Capability c : SourceCapabilities.Capability.values())
    System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they are declared

valueOf

public static SourceCapabilities.Capability valueOf(java.lang.String name)

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

java.lang.IllegalArgumentException - if this enum type has no constant with the specified name

java.lang.NullPointerException - if the argument is null