org.teiid.translator.jdbc.db2

Class DB2ExecutionFactory

java.lang.Object

org.teiid.translator.ExecutionFactory<DataSource,Connection>

org.teiid.translator.jdbc.JDBCExecutionFactory

org.teiid.translator.jdbc.db2.BaseDB2ExecutionFactory

org.teiid.translator.jdbc.db2.DB2ExecutionFactory

@Translator(name="db2",
            description="A translator for IBM DB2 Database")
public class DB2ExecutionFactory
extends BaseDB2ExecutionFactory

Nested Class Summary

Nested classes/interfaces inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

JDBCExecutionFactory.StructRetrieval

Nested classes/interfaces inherited from class org.teiid.translator.ExecutionFactory

ExecutionFactory.Format, ExecutionFactory.NullOrder, ExecutionFactory.SupportedJoinCriteria, ExecutionFactory.TransactionSupport

Field Summary

Fields

Modifier and Type	Field and Description
static Version	NINE_1
static Version	NINE_5
static Version	SIX_1
static Version	TEN_0

Fields inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

DEFAULT_MAX_DEPENDENT_PREDICATES, DEFAULT_MAX_IN_CRITERIA, DEFAULT_TIME_ZONE, dialect

Fields inherited from class org.teiid.translator.ExecutionFactory

DEFAULT_MAX_FROM_GROUPS, DEFAULT_MAX_IN_CRITERIA_SIZE, DEFAULT_MAX_PROJECTED_COLUMNS

Constructor Summary

Constructors

Constructor and Description
DB2ExecutionFactory()

Method Summary

Modifier and Type	Method and Description
String	getHibernateDialectClassName()
MetadataProcessor<Connection>	getMetadataProcessor() Get a MetadataProcessor for the translator to read the metadata.
List<String>	getSupportedFunctions() Get list of all supported function names.
String	getTemporaryTableName(String prefix)
boolean	isdB2ForI()
void	setdB2ForI(boolean dB2ForI)
void	setSupportsCommonTableExpressions(boolean supportsCommonTableExpressions)
void	start() Initialize the connector with supplied configuration
boolean	supportsAggregatesEnhancedNumeric() Support indicates connector can accept STDDEV_POP, STDDEV_VAR, VAR_POP, VAR_SAMP
protected boolean	supportsBooleanExpressions() if boolean expressions are directly supported.
boolean	supportsCommonTableExpressions()
boolean	supportsElementaryOlapOperations()
boolean	supportsFunctionsInGroupBy() Support indicates that the connector supports non-column expressions in GROUP BY, such as: SELECT dayofmonth(theDate), COUNT(*) FROM table GROUP BY dayofmonth(theDate)
boolean	supportsGroupByRollup()
boolean	supportsRecursiveCommonTableExpressions()
boolean	supportsRowLimit() Gets whether the connector can limit the number of rows returned by a query.
boolean	supportsWindowFunctionCumeDist()
boolean	supportsWindowFunctionNthValue()
boolean	supportsWindowFunctionNtile()
boolean	supportsWindowFunctionPercentRank()
protected boolean	usesDatabaseVersion()

Methods inherited from class org.teiid.translator.jdbc.db2.BaseDB2ExecutionFactory

convertCrossJoinToInner, getDefaultNullOrder, supportsExcept, supportsInlineViews, supportsIntersect, supportsSelectWithoutFrom, supportsSubqueryInOn, translate, translateCommand, translateLimit

Methods inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

addSourceComment, afterInitialConnectionObtained, bindValue, closeConnection, convertObject, createDirectExecution, createMetadataProcessor, createProcedureExecution, createResultSetExecution, createTempTable, createUpdateExecution, executeStoredProcedure, formatDateValue, formatDateValue, getCommentFormat, getConnection, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCreateTempTableSQL, getDatabaseCalendar, getDatabaseTimeZone, getDatabaseVersion, getDefaultSupportedFunctions, getDialect, getFunctionModifiers, getLateralKeyword, getLikeRegexString, getMaxPreparedInsertBatchSize, getMetadata, getRemovePushdownCharacters, getSetOperationString, getSourceComment, getSQLConversionVisitor, getStructRetrieval, getTimestampNanoPrecision, getVersion, hasTimeType, initCapabilities, intializeConnectionAfterCancel, isCharacterType, isDefaultTimeZone, isEnableDependentJoins, isExtendedAscii, isNonAscii, isNonAscii, isNonAsciiFunction, isSourceRequired, isSourceRequiredForCapabilities, isTrimStrings, loadedTemporaryTable, obtainedConnection, registerFunctionModifier, registerSpecificTypeOfOutParameter, replaceElementName, retrieveGeographyValue, retrieveGeographyValue, retrieveGeometryValue, retrieveGeometryValue, retrieveValue, retrieveValue, setCommentFormat, setDatabaseTimeZone, setDatabaseVersion, setDatabaseVersion, setEnableDependentJoins, setFetchSize, setMaxPreparedInsertBatchSize, setRemovePushdownCharacters, setStructRetrieval, setTrimStrings, setUseBindingsForDependentJoin, setUseBindVariables, setUseCommentsInSourceQuery, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedTable, supportsBatchedUpdates, supportsBulkUpdate, supportsCompareCriteriaEquals, supportsCompareCriteriaOrdered, supportsCorrelatedSubqueries, supportsDependentJoins, supportsExistsCriteria, supportsFullDependentJoins, supportsGeneratedKeys, supportsGeneratedKeys, supportsGroupBy, supportsHaving, supportsInCriteria, supportsInCriteriaSubquery, supportsInsertWithQueryExpression, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsOrderByUnrelated, supportsProcedureParameterExpression, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions, tempTableRequiresTransaction, translateGeographyLiteral, translateGeographyParameter, translateGeographySelect, translateGeometryLiteral, translateGeometryParameter, translateGeometrySelect, translateLiteralBinaryType, translateLiteralBoolean, translateLiteralDate, translateLiteralTime, translateLiteralTimestamp, useAsInGroupAlias, useBindingsForDependentJoin, useBindVariables, useColumnNamesForGeneratedKeys, useCommentsInSourceQuery, useNBindingType, useParensForJoins, useParensForSetQueries, usePreparedStatements, useScientificNotation, useSelectLimit, useStreamsForLobs, useUnicodePrefix, useWithRollup

Methods inherited from class org.teiid.translator.ExecutionFactory

addPushDownFunction, areLobsUsableAfterClose, createExecution, getCacheDirective, getCollationLocale, getConnection, getDirectQueryProcedureName, getExcludedCommonTableExpressionName, getInstance, getLanguageFactory, getMaxDependentInPredicates, getMaxFromGroups, getMaxInCriteriaSize, getMaxProjectedColumns, getNativeQueryProcedureName, getPushDownFunctions, getRequiredLikeEscape, getSupportedJoinCriteria, getTransactionSupport, getTypeFacility, isCopyLobs, isForkable, isImmutable, isSourceRequiredForMetadata, isThreadBound, requiresCriteria, returnsSingleUpdateCount, setCollationLocale, setCopyLobs, setDirectQueryProcedureName, setExcludedCommonTableExpressionName, setImmutable, setMaxDependentInPredicates, setMaxInCriteriaSize, setNativeQueryProcedureName, setRequiresCriteria, setSourceRequired, setSourceRequiredForMetadata, setSupportedJoinCriteria, setSupportsDirectQueryProcedure, setSupportsFullOuterJoins, setSupportsInnerJoins, setSupportsNativeQueries, setSupportsOrderBy, setSupportsOuterJoins, setSupportsSelectDistinct, setThreadBound, setTransactionSupport, supportsAdvancedOlapOperations, supportsAggregatesCountBig, supportsArrayAgg, supportsArrayType, supportsCompareCriteriaOrderedExclusive, supportsConvert, supportsCorrelatedSubqueryLimit, supportsDirectQueryProcedure, supportsFormatLiteral, supportsFullOuterJoins, supportsGeographyType, supportsGroupByMultipleDistinctAggregates, supportsInnerJoins, supportsIsDistinctCriteria, supportsLateralJoin, supportsLateralJoinCondition, supportsLikeRegex, supportsListAgg, supportsMultipleOpenExecutions, supportsNativeQueries, supportsOnlyCorrelatedSubqueries, supportsOnlyFormatLiterals, supportsOnlyLateralJoinProcedure, supportsOnlyLiteralComparison, supportsOnlySingleTableGroupBy, supportsOnlyTimestampAddLiteral, supportsOrderBy, supportsOrderByNullOrdering, supportsOrderByWithExtendedGrouping, supportsOuterJoins, supportsPartialFiltering, supportsProcedureTable, supportsRowOffset, supportsScalarSubqueryProjection, supportsSelectDistinct, supportsSelectExpressionArrayType, supportsSetQueryLimitOffset, supportsSimilarTo, supportsStringAgg, supportsSubqueryCommonTableExpressions, supportsUpsert, supportsWindowDistinctAggregates, supportsWindowFrameClause, supportsWindowOrderByWithAggregates, useAnsiJoin

Methods inherited from class java.lang.Object

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

Field Detail

NINE_1

public static final Version NINE_1

NINE_5

public static final Version NINE_5

TEN_0

public static final Version TEN_0

SIX_1

public static final Version SIX_1

Constructor Detail

DB2ExecutionFactory

public DB2ExecutionFactory()

Method Detail

getSupportedFunctions

public List<String> getSupportedFunctions()

Description copied from class: ExecutionFactory

Get list of all supported function names. Arithmetic functions have names like "+".

Overrides:

getSupportedFunctions in class JDBCExecutionFactory

See Also:

for a listing of system pushdown functions. Note that not all system functions are listed as some functions will use a common name such as CONCAT vs. the || operator, and other functions will be rewritten and not pushed down, such as SPACE.
Note: User defined functions should be specified fully qualified.

supportsFunctionsInGroupBy

public boolean supportsFunctionsInGroupBy()

Description copied from class: ExecutionFactory

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

Overrides:

supportsFunctionsInGroupBy in class ExecutionFactory<DataSource,Connection>

supportsAggregatesEnhancedNumeric

public boolean supportsAggregatesEnhancedNumeric()

Description copied from class: ExecutionFactory

Support indicates connector can accept STDDEV_POP, STDDEV_VAR, VAR_POP, VAR_SAMP

Overrides:

supportsAggregatesEnhancedNumeric in class ExecutionFactory<DataSource,Connection>

setSupportsCommonTableExpressions

public void setSupportsCommonTableExpressions(boolean supportsCommonTableExpressions)

supportsCommonTableExpressions

@TranslatorProperty(display="Supports Common Table Expressions",
                    description="Supports Common Table Expressions",
                    advanced=true)
public boolean supportsCommonTableExpressions()

Overrides:

supportsCommonTableExpressions in class ExecutionFactory<DataSource,Connection>

Returns:

true if the WITH clause is supported

supportsRowLimit

public boolean supportsRowLimit()

Description copied from class: ExecutionFactory

Gets whether the connector can limit the number of rows returned by a query.

Overrides:

supportsRowLimit in class ExecutionFactory<DataSource,Connection>

supportsElementaryOlapOperations

public boolean supportsElementaryOlapOperations()

Overrides:

supportsElementaryOlapOperations in class ExecutionFactory<DataSource,Connection>

Returns:

true if Elementary OLAP operations are supported including window functions and inline window specifications that include simple expressions in partitioning and ordering

supportsWindowFunctionNtile

public boolean supportsWindowFunctionNtile()

Overrides:

supportsWindowFunctionNtile in class ExecutionFactory<DataSource,Connection>

Returns:

true if ntile is supported. defaults to ExecutionFactory.supportsElementaryOlapOperations()

supportsWindowFunctionPercentRank

public boolean supportsWindowFunctionPercentRank()

Overrides:

supportsWindowFunctionPercentRank in class ExecutionFactory<DataSource,Connection>

Returns:

true if percent_rank is supported. defaults to ExecutionFactory.supportsElementaryOlapOperations()

supportsWindowFunctionCumeDist

public boolean supportsWindowFunctionCumeDist()

Overrides:

supportsWindowFunctionCumeDist in class ExecutionFactory<DataSource,Connection>

Returns:

true if cume_dist is supported. defaults to ExecutionFactory.supportsElementaryOlapOperations()

supportsWindowFunctionNthValue

public boolean supportsWindowFunctionNthValue()

Overrides:

supportsWindowFunctionNthValue in class ExecutionFactory<DataSource,Connection>

Returns:

true if nth_value is supported. defaults to ExecutionFactory.supportsElementaryOlapOperations()

start

public void start()
           throws TranslatorException

Description copied from class: ExecutionFactory

Initialize the connector with supplied configuration

Overrides:

start in class BaseDB2ExecutionFactory

Throws:

TranslatorException

isdB2ForI

@TranslatorProperty(display="Is DB2 for i",
                    description="If the server is DB2 for i (formally known as DB2/AS).",
                    advanced=true)
public boolean isdB2ForI()

setdB2ForI

public void setdB2ForI(boolean dB2ForI)

usesDatabaseVersion

protected boolean usesDatabaseVersion()

Overrides:

usesDatabaseVersion in class JDBCExecutionFactory

getHibernateDialectClassName

public String getHibernateDialectClassName()

Overrides:

getHibernateDialectClassName in class JDBCExecutionFactory

getTemporaryTableName

public String getTemporaryTableName(String prefix)

Overrides:

getTemporaryTableName in class JDBCExecutionFactory

Returns:

a valid temporary table name

supportsGroupByRollup

public boolean supportsGroupByRollup()

Overrides:

supportsGroupByRollup in class ExecutionFactory<DataSource,Connection>

Returns:

true if the translator support GROUP BY ROLLUP

supportsBooleanExpressions

protected boolean supportsBooleanExpressions()

Description copied from class: JDBCExecutionFactory

if boolean expressions are directly supported. will generally be false if there is no boolean datatype

Overrides:

supportsBooleanExpressions in class JDBCExecutionFactory

Returns:

getMetadataProcessor

public MetadataProcessor<Connection> getMetadataProcessor()

Description copied from class: ExecutionFactory

Get a MetadataProcessor for the translator to read the metadata. Typically this will return a new instance.

Overrides:

getMetadataProcessor in class JDBCExecutionFactory

Returns:

supportsRecursiveCommonTableExpressions

public boolean supportsRecursiveCommonTableExpressions()

Overrides:

supportsRecursiveCommonTableExpressions in class ExecutionFactory<DataSource,Connection>

Returns:

true if a recursive WITH clause item is supported