public class Db2SqlDialect extends SqlDialect
SqlDialect
implementation for the IBM DB2 database.SqlDialect.CalendarPolicy, SqlDialect.Context, SqlDialect.DatabaseProduct, SqlDialect.FakeUtil
Modifier and Type | Field and Description |
---|---|
static SqlDialect |
DEFAULT |
BUILT_IN_OPERATORS_LIST, CALCITE, DUMMY, EMPTY_CONTEXT, LOGGER, nullCollation
Constructor and Description |
---|
Db2SqlDialect(SqlDialect.Context context)
Creates a Db2SqlDialect.
|
Modifier and Type | Method and Description |
---|---|
boolean |
hasImplicitTableAlias()
Returns whether a qualified table in the FROM clause has an implicit alias
which consists of just the table name.
|
boolean |
supportsCharSet()
Returns whether the dialect supports character set names as part of a
data type, for instance
VARCHAR(30) CHARACTER SET `ISO-8859-1` . |
void |
unparseSqlIntervalLiteral(SqlWriter writer,
SqlIntervalLiteral literal,
int leftPrec,
int rightPrec)
Converts an interval literal to a SQL string.
|
void |
unparseSqlIntervalQualifier(SqlWriter writer,
SqlIntervalQualifier qualifier,
RelDataTypeSystem typeSystem)
Converts an interval qualifier to a SQL string.
|
allowsAs, configureParser, create, defaultNullDirection, emptyContext, emulateJoinTypeForCrossJoin, emulateNullDirection, emulateNullDirectionWithIsNull, getCalendarPolicy, getCastSpec, getConformance, getDatabaseProduct, getNullCollation, getProduct, getQuotedCasing, getQuoting, getTypeSystem, getUnquotedCasing, isCaseSensitive, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteStringLiteral, quoteStringLiteralUnicode, quoteTimestampLiteral, requiresAliasForFromItems, rewriteSingleValueExpr, supportsAggregateFunction, supportsAliasedValues, supportsFunction, supportsGroupByWithCube, supportsGroupByWithRollup, supportsNestedAggregations, supportsOffsetFetch, supportsWindowFunctions, unparseCall, unparseDateTimeLiteral, unparseFetchUsingAnsi, unparseFetchUsingLimit, unparseOffsetFetch, unparseSqlDatetimeArithmetic, unquoteStringLiteral
public static final SqlDialect DEFAULT
public Db2SqlDialect(SqlDialect.Context context)
public boolean supportsCharSet()
SqlDialect
VARCHAR(30) CHARACTER SET `ISO-8859-1`
.supportsCharSet
in class SqlDialect
public boolean hasImplicitTableAlias()
SqlDialect
For example, in SqlDialect.DatabaseProduct.ORACLE
SELECT * FROM sales.emp
is equivalent to
SELECT * FROM sales.emp AS emp
and therefore
SELECT emp.empno FROM sales.emp
is valid. But SqlDialect.DatabaseProduct.DB2
does not have an implicit
alias, so the previous query it not valid; you need to write
SELECT sales.emp.empno FROM sales.emp
Returns true for all databases except DB2.
hasImplicitTableAlias
in class SqlDialect
public void unparseSqlIntervalQualifier(SqlWriter writer, SqlIntervalQualifier qualifier, RelDataTypeSystem typeSystem)
SqlDialect
INTERVAL '1 2:3:4' DAY(4) TO SECOND(4)
.unparseSqlIntervalQualifier
in class SqlDialect
public void unparseSqlIntervalLiteral(SqlWriter writer, SqlIntervalLiteral literal, int leftPrec, int rightPrec)
SqlDialect
INTERVAL '1 2:3:4' DAY(4) TO SECOND(4)
.unparseSqlIntervalLiteral
in class SqlDialect
Copyright © 2012–2019 The Apache Software Foundation. All rights reserved.