org.teiid.connector.jdbc.sybase
Class SybaseCapabilities

java.lang.Object
  org.teiid.connector.basic.BasicConnectorCapabilities
      org.teiid.connector.jdbc.JDBCCapabilities
          org.teiid.connector.jdbc.sybase.SybaseCapabilities

All Implemented Interfaces:

ConnectorCapabilities

public class SybaseCapabilities
extends JDBCCapabilities

Nested Class Summary

Nested classes/interfaces inherited from interface org.teiid.connector.api.ConnectorCapabilities

ConnectorCapabilities.SupportedJoinCriteria

Constructor Summary

SybaseCapabilities()

Method Summary

int	getMaxFromGroups() The number of groups supported in the from clause.
int	getMaxInCriteriaSize() Get the integer value representing the number of values allowed in an IN criteria in the WHERE clause of a query
java.util.List	getSupportedFunctions() Return null to indicate no functions are supported.
boolean	supportsFunctionsInGroupBy() Support indicates that the connector supports functions in GROUP BY, such as: SELECT dayofmonth(theDate), COUNT(*) FROM table GROUP BY dayofmonth(theDate)
boolean	supportsInlineViews() Support indicates connector can accept inline views (subqueries in the FROM clause).
boolean	supportsIntersect() Support indicates that the connector supports the INTERSECT of two queries.

Methods inherited from class org.teiid.connector.jdbc.JDBCCapabilities

getSupportedJoinCriteria, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedGroup, supportsBatchedUpdates, supportsBetweenCriteria, supportsBulkUpdate, supportsCaseExpressions, supportsCompareCriteriaEquals, supportsCompareCriteriaOrdered, supportsCorrelatedSubqueries, supportsExistsCriteria, supportsFullOuterJoins, supportsGroupBy, supportsHaving, supportsInCriteria, supportsInCriteriaSubquery, supportsInnerJoins, supportsInsertWithQueryExpression, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsOrderBy, supportsOuterJoins, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectDistinct, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions

Methods inherited from class org.teiid.connector.basic.BasicConnectorCapabilities

requiresCriteria, supportsExcept, supportsRowLimit, supportsRowOffset, useAnsiJoin

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SybaseCapabilities

public SybaseCapabilities()

Method Detail

getMaxInCriteriaSize

public int getMaxInCriteriaSize()

Description copied from interface: ConnectorCapabilities

Get the integer value representing the number of values allowed in an IN criteria in the WHERE clause of a query

Specified by:

getMaxInCriteriaSize in interface ConnectorCapabilities

Overrides:

getMaxInCriteriaSize in class JDBCCapabilities

See Also:

BasicConnectorCapabilities.getMaxInCriteriaSize()

getSupportedFunctions

public java.util.List getSupportedFunctions()

Description copied from class: BasicConnectorCapabilities

Return null to indicate no functions are supported.

Specified by:

getSupportedFunctions in interface ConnectorCapabilities

Overrides:

getSupportedFunctions in class JDBCCapabilities

Returns:

null

See Also:

com.metamatrix.data.ConnectorCapabilities#getSupportedFunctions()

supportsInlineViews

public boolean supportsInlineViews()

Description copied from interface: ConnectorCapabilities

Support indicates connector can accept inline views (subqueries in the FROM clause).

Specified by:

supportsInlineViews in interface ConnectorCapabilities

Overrides:

supportsInlineViews in class JDBCCapabilities

See Also:

ConnectorCapabilities.supportsInlineViews()

supportsFunctionsInGroupBy

public boolean supportsFunctionsInGroupBy()

Description copied from interface: ConnectorCapabilities

Support indicates that the connector supports functions in GROUP BY, such as: SELECT dayofmonth(theDate), COUNT(*) FROM table GROUP BY dayofmonth(theDate)

NOT CURRENTLY USED - group by expressions create an inline view for pushdown

Specified by:

supportsFunctionsInGroupBy in interface ConnectorCapabilities

Overrides:

supportsFunctionsInGroupBy in class BasicConnectorCapabilities

Since:

5.0

See Also:

ConnectorCapabilities.supportsFunctionsInGroupBy()

getMaxFromGroups

public int getMaxFromGroups()

Description copied from interface: ConnectorCapabilities

The number of groups supported in the from clause. Added for a Sybase limitation.

Specified by:

getMaxFromGroups in interface ConnectorCapabilities

Overrides:

getMaxFromGroups in class BasicConnectorCapabilities

Returns:

the number of groups supported in the from clause, or -1 if there is no limit

See Also:

BasicConnectorCapabilities.getMaxFromGroups()

supportsIntersect

public boolean supportsIntersect()

Description copied from interface: ConnectorCapabilities

Support indicates that the connector supports the INTERSECT of two queries.

Specified by:

supportsIntersect in interface ConnectorCapabilities

Overrides:

supportsIntersect in class BasicConnectorCapabilities

See Also:

BasicConnectorCapabilities.supportsIntersect()