java.lang.Object
- org.hibernate.dialect.Dialect
- - org.hibernate.dialect.DB2Dialect

All Implemented Interfaces:

FunctionContributor, TypeContributor, ConversionContext

Direct Known Subclasses:

DB2390Dialect, DB2400Dialect, DB297Dialect, DB2iDialect, DB2zDialect
```
public class DB2Dialect
extends Dialect
```
A SQL dialect for DB2 for LUW (Linux, Unix, and Windows) version 10.5 and above.

Nested Class Summary
- Nested classes/interfaces inherited from class org.hibernate.dialect.Dialect
  Dialect.SizeStrategy, Dialect.SizeStrategyImpl

Field Summary
- Fields inherited from class org.hibernate.dialect.Dialect
  CLOSED_QUOTE, LEGACY_LOB_MERGE_STRATEGY, LOG_BASE2OF10, NEW_LOCATOR_LOB_MERGE_STRATEGY, QUOTE, STANDARD_DEFAULT_BATCH_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY

Constructor Summary

Constructors
Constructor Description

DB2Dialect()

DB2Dialect(DatabaseVersion version)

DB2Dialect(DialectResolutionInfo info)

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`void`	`appendBinaryLiteral(SqlAppender appender, byte[] bytes)`	Append a binary literal to the given `SqlAppender`.
`void`	`appendBooleanValueString(SqlAppender appender, boolean bool)`	Append the SQL literal expression representing the given boolean value to the given `SqlAppender`.
`void`	`appendDatetimeFormat(SqlAppender appender, String format)`	Translate the given datetime format string from the pattern language defined by Java's `DateTimeFormatter` to whatever pattern language is understood by the native datetime formatting function for this database (often the `to_char()` function).
`void`	`appendDateTimeLiteral(SqlAppender appender, TemporalAccessor temporalAccessor, TemporalType precision, TimeZone jdbcTimeZone)`	Append a datetime literal representing the given `java.time` value to the given `SqlAppender`.
`void`	`appendDateTimeLiteral(SqlAppender appender, Calendar calendar, TemporalType precision, TimeZone jdbcTimeZone)`	Append a datetime literal representing the given `Calendar` value to the given `SqlAppender`.
`void`	`appendDateTimeLiteral(SqlAppender appender, Date date, TemporalType precision, TimeZone jdbcTimeZone)`	Append a datetime literal representing the given `Date` value to the given `SqlAppender`.
`IdentifierHelper`	`buildIdentifierHelper(IdentifierHelperBuilder builder, DatabaseMetaData dbMetaData)`	The `IdentifierHelper` indicated by this dialect for handling identifier conversions.
`SQLExceptionConversionDelegate`	`buildSQLExceptionConversionDelegate()`	An instance of `SQLExceptionConversionDelegate` for interpreting dialect-specific error or SQLState codes.
`boolean`	`canDisableConstraints()`	Is there some way to disable foreign key constraint checking while truncating tables? (If there's no way to do it, and if we can't batch truncate, we must drop and recreate the constraints instead.)
`protected String`	`columnType(int sqlTypeCode)`	The database column type name for a given JDBC type code defined in `Types` or `SqlTypes`.
`void`	`contributeTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)`	A callback which allows the `Dialect` to contribute types.
`protected UniqueDelegate`	`createUniqueDelegate()`
`boolean`	`doesReadCommittedCauseWritersToBlockReaders()`	For the underlying database, is `READ_COMMITTED` isolation implemented by forcing readers to wait for write locks to be released?
`boolean`	`dropConstraints()`	Do we need to drop constraints before dropping tables in this dialect?
`String`	`extractPattern(TemporalUnit unit)`	Obtain a pattern for the SQL equivalent to an `extract()` function call.
`String`	`generatedAs(String generatedAs)`	The `generated as` clause, or similar, for generated column declarations in DDL statements.
`AggregateSupport`	`getAggregateSupport()`	How does this dialect support aggregate types like `SqlTypes.STRUCT`.
`String`	`getAlterColumnTypeString(String columnName, String columnType, String columnDefinition)`	The fragment of an `alter table` command which modifies a column type, or null if column types cannot be modified.
`CallableStatementSupport`	`getCallableStatementSupport()`	The `CallableStatementSupport` for this database.
`String`	`getCreateIndexTail(boolean unique, List<Column> columns)`	A string to be appended to the end of the `create index` command, usually to specify that `null` values are to be considered distinct.
`String`	`getCreateUserDefinedTypeExtensionsString()`	An arbitrary extension to append to the end of the UDT `create type` command.
`String`	`getCurrentTimestampSelectString()`	The command used to retrieve the current timestamp from the database.
`DatabaseVersion`	`getDB2Version()`	DB2 LUW Version
`int`	`getDefaultDecimalPrecision()`	This is the default precision for a generated column mapped to a `BigInteger` or `BigDecimal`.
`int`	`getDefaultStatementBatchSize()`	The default value to use for the configuration property "hibernate.jdbc.batch_size".
`String`	`getDisableConstraintStatement(String tableName, String name)`	A SQL statement that temporarily disables checking of the given foreign key constraint.
`String[]`	`getDropSchemaCommand(String schemaName)`	Get the SQL command used to drop the named schema.
`String`	`getEnableConstraintStatement(String tableName, String name)`	A SQL statement that re-enables checking of the given foreign key constraint.
`SqmMultiTableInsertStrategy`	`getFallbackSqmInsertStrategy(EntityMappingType rootEntityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)`	The `SqmMultiTableInsertStrategy` to use when not specified by `QueryEngineOptions.getCustomSqmMultiTableInsertStrategy()`.
`SqmMultiTableMutationStrategy`	`getFallbackSqmMutationStrategy(EntityMappingType rootEntityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)`	The `SqmMultiTableMutationStrategy` to use when not specified by `QueryEngineOptions.getCustomSqmMultiTableMutationStrategy()`.
`String`	`getForUpdateSkipLockedString()`	Retrieves the `FOR UPDATE SKIP LOCKED` syntax specific to this dialect.
`String`	`getForUpdateSkipLockedString(String aliases)`	Get the `FOR UPDATE OF column_list SKIP LOCKED` fragment appropriate for this dialect, given the aliases of the columns to be write locked.
`String`	`getForUpdateString()`	Get the string to append to `SELECT` statements to acquire pessimistic UPGRADE locks for this dialect.
`long`	`getFractionalSecondPrecisionInNanos()`	Since we're using `seconds_between()` and `add_seconds()`, it makes sense to use seconds as the "native" precision.
`IdentityColumnSupport`	`getIdentityColumnSupport()`	Get the appropriate `IdentityColumnSupport` for this dialect.
`int`	`getInExpressionCountLimit()`	Return the limit that the underlying database places on the number of elements in an `IN` predicate.
`LimitHandler`	`getLimitHandler()`	Obtain a `LimitHandler` that implements pagination support for `Query.setMaxResults(int)` and `Query.setFirstResult(int)`.
`int`	`getMaxIdentifierLength()`	What is the maximum identifier length supported by this dialect?
`int`	`getMaxVarcharLength()`	The biggest size value that can be supplied as argument to a `Types.VARCHAR`-like type.
`protected DatabaseVersion`	`getMinimumSupportedVersion()`	Get the version of the SQL dialect that is the minimum supported by this implementation.
`String`	`getQuerySequencesString()`	Get the `select` command used retrieve the names of all sequences.
`String`	`getReadLockString(int timeout)`	Get the string to append to `SELECT` statements to acquire READ locks for this dialect.
`ResultSet`	`getResultSet(CallableStatement ps)`	Given a callable statement previously processed by `Dialect.registerResultSetOutParameter(java.sql.CallableStatement, int)`, extract the `ResultSet` from the `OUT` parameter.
`String`	`getSelectClauseNullString(int sqlType, TypeConfiguration typeConfiguration)`	Given a JDBC type code, return the expression for a literal null value of that type, to use in a `select` clause.
`SequenceInformationExtractor`	`getSequenceInformationExtractor()`	A `SequenceInformationExtractor` which is able to extract `SequenceInformation` from the JDBC result set returned when `Dialect.getQuerySequencesString()` is executed.
`SequenceSupport`	`getSequenceSupport()`	Get the appropriate `SequenceSupport` for this dialect.
`SqlAstTranslatorFactory`	`getSqlAstTranslatorFactory()`	Return a `SqlAstTranslatorFactory` specific to this dialect, or `null` to use the standard translator.
`String`	`getTruncateTableStatement(String tableName)`	A SQL statement that truncates the given table.
`UniqueDelegate`	`getUniqueDelegate()`	Get the `UniqueDelegate` supported by this dialect
`String`	`getWriteLockString(int timeout)`	Get the string to append to `SELECT` statements to acquire pessimistic WRITE locks for this dialect.
`void`	`initializeFunctionRegistry(FunctionContributions functionContributions)`	Initialize the given registry with any dialect-specific functions.
`boolean`	`isCurrentTimestampSelectStringCallable()`	Is the command returned by `Dialect.getCurrentTimestampSelectString()` treated as callable?
`protected void`	`registerColumnTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)`	Register ANSI-standard column types using the length limits defined by `Dialect.getMaxVarcharLength()`, `Dialect.getMaxNVarcharLength()`, and `Dialect.getMaxVarbinaryLength()`.
`protected void`	`registerDefaultKeywords()`	Register the reserved words of ANSI-standard SQL as keywords.
`int`	`registerResultSetOutParameter(CallableStatement statement, int col)`	Registers a parameter capable of returning a `ResultSet` by position, either an `OUT` parameter, or a `REF_CURSOR` parameter as defined in Java 8.
`boolean`	`requiresCastForConcatenatingNonStrings()`	Does this dialect/database require casting of non-string arguments in the `concat()` function?
`String`	`rowId(String rowId)`	The more "standard" syntax is `rid_bit(alias)` but here we use `alias.rowid`.
`int`	`rowIdSqlType()`	The JDBC type code of the `rowid`-like pseudo-column which acts as a high-performance row locator.
`static String`	`selectNullString(int sqlType)`
`boolean`	`supportsAlterColumnType()`	Does this dialect support modifying the type of an existing column?
`boolean`	`supportsCommentOn()`	Does this dialect support commenting on tables and columns?
`boolean`	`supportsCurrentTimestampSelection()`	Does this dialect support some way to retrieve the current timestamp value from the database?
`boolean`	`supportsDistinctFromPredicate()`	Does this dialect support some kind of `distinct from` predicate?
`boolean`	`supportsExistsInSelect()`	Does the dialect support an exists statement in the select clause?
`boolean`	`supportsInsertReturning()`	Does this dialect fully support returning arbitrary generated column values after execution of an `insert` statement, using native SQL syntax?
`boolean`	`supportsLateral()`	Does this dialect support the SQL `lateral` keyword or a proprietary alternative?
`boolean`	`supportsLobValueChangePropagation()`	Does the dialect support propagating changes to LOB values back to the database? Talking about mutating the internal value of the locator, as opposed to supplying a new locator instance.
`boolean`	`supportsLockTimeouts()`	Does this dialect support specifying timeouts when requesting locks.
`boolean`	`supportsNonQueryWithCTE()`	Does this dialect support insert, update, and delete statements with Common Table Expressions (CTEs)?
`boolean`	`supportsNullPrecedence()`	Does this dialect support `nulls first` and `nulls last`?
`boolean`	`supportsOffsetInSubquery()`	Does this dialect support `offset` in subqueries?
`boolean`	`supportsOuterJoinForUpdate()`	Does this dialect support `FOR UPDATE` in conjunction with outer-joined rows?
`boolean`	`supportsPartitionBy()`	Does is dialect support `partition by`?
`protected boolean`	`supportsPredicateAsExpression()`	Whether a predicate like `a > 0` can appear in an expression context, for example, in a `select` list item.
`boolean`	`supportsRecursiveCTE()`	Does this dialect/database support recursive CTEs?
`boolean`	`supportsResultSetPositionQueryMethodsOnForwardOnlyCursor()`	Does this dialect support asking the result set its positioning information on forward-only cursors?
`boolean`	`supportsSkipLocked()`	Does this dialect support `SKIP_LOCKED` timeout.
`boolean`	`supportsTupleDistinctCounts()`	Does this dialect support `count(distinct a,b)`?
`boolean`	`supportsValuesList()`	Does this dialect support `values` lists of form `VALUES (1), (2), (3)`?
`boolean`	`supportsWindowFunctions()`	Does this dialect support window functions like `row_number() over (..)`?
`String`	`timestampaddPattern(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType)`	Obtain a pattern for the SQL equivalent to a `timestampadd()` function call.
`String`	`timestampdiffPattern(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType)`	Obtain a pattern for the SQL equivalent to a `timestampdiff()` function call.
`static String`	`timestampdiffPatternV10(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType)`
`String`	`translateExtractField(TemporalUnit unit)`	Return the name used to identify the given field as an argument to the `extract()` function, or of this dialect's equivalent function.

Methods inherited from class org.hibernate.dialect.Dialect
addSqlHintOrComment, appendArrayLiteral, appendIntervalLiteral, appendLiteral, appendLockHint, appendUUIDLiteral, applyLocksToSql, augmentPhysicalTableTypes, augmentRecognizedTableTypes, canBatchTruncate, canCreateCatalog, canCreateSchema, castPattern, castType, checkVersion, closeQuote, contribute, contributeFunctions, createOptionalTableUpdateOperation, currentDate, currentLocalTime, currentLocalTimestamp, currentTime, currentTimestamp, currentTimestampWithTimeZone, defaultScrollMode, doesRepeatableReadCauseReadersToBlockWriters, equivalentTypes, escapeComment, forceLobAsLastValue, getAddColumnString, getAddColumnSuffixString, getAddForeignKeyConstraintString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAlterTableString, getArrayTypeName, getAuxiliaryDatabaseObjectExporter, getCascadeConstraintsString, getCaseInsensitiveLike, getCheckCondition, getCheckCondition, getColumnAliasExtractor, getColumnComment, getCreateCatalogCommand, getCreateIndexString, getCreateMultisetTableString, getCreateSchemaCommand, getCreateTableString, getCreateTemporaryTableColumnAnnotation, getCreateUserDefinedTypeKindString, getCurrentSchemaCommand, getDefaultBatchLoadSizingStrategy, getDefaultLobLength, getDefaultNonContextualLobCreation, getDefaultProperties, getDefaultTimestampPrecision, getDefaultUseGetGeneratedKeys, getDisableConstraintsStatement, getDoublePrecision, getDropCatalogCommand, getDropForeignKeyString, getDropTableString, getDropUniqueKeyString, getEnableConstraintsStatement, getEnumTypeDeclaration, getFallbackSchemaManagementTool, getFloatPrecision, getForeignKeyExporter, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getGroupBySelectItemReferenceStrategy, getHqlTranslator, getIndexExporter, getKeywords, getLobMergeStrategy, getLockingStrategy, getLockRowIdentifier, getLowercaseFunction, getMaxAliasLength, getMaxNVarcharCapacity, getMaxNVarcharLength, getMaxVarbinaryCapacity, getMaxVarbinaryLength, getMaxVarcharCapacity, getNameQualifierSupport, getNationalizationSupport, getNativeIdentifierGenerationType, getNativeIdentifierGeneratorStrategy, getNoColumnsInsertString, getNullColumnString, getNullColumnString, getNullOrdering, getPreferredSqlTypeCodeForArray, getPreferredSqlTypeCodeForBoolean, getQueryHintString, getQueryHintString, getReadLockString, getReadRowLockStrategy, getResultSet, getResultSet, getRowIdColumnString, getSchemaNameResolver, getSelectGUIDString, getSequenceExporter, getSizeStrategy, getSqmTranslatorFactory, getSupportedTemporaryTableKind, getTableCleaner, getTableComment, getTableExporter, getTableMigrator, getTableTypeString, getTemporaryTableAfterUseAction, getTemporaryTableBeforeUseAction, getTemporaryTableCreateCommand, getTemporaryTableCreateOptions, getTemporaryTableDdlTransactionHandling, getTemporaryTableDropCommand, getTemporaryTableExporter, getTemporaryTableTruncateCommand, getTimeZoneSupport, getTruncateTableStatements, getUniqueKeyExporter, getUserDefinedTypeComment, getUserDefinedTypeExporter, getVersion, getViolatedConstraintNameExtractor, getWriteLockString, getWriteRowLockStrategy, hasAlterTable, hasDataTypeBeforeGeneratedAs, hasSelfReferentialForeignKeyBug, initDefaultProperties, inlineLiteral, isAnsiNullOn, isEmptyStringTreatedAsNull, isJdbcLogWarningsEnabledByDefault, isLockTimeoutParameterized, openQuote, ordinal, prependComment, qualifyIndexName, quote, registerKeyword, registerKeywords, registerResultSetOutParameter, requiresFloatCastingOfIntegerDivision, requiresParensForTupleCounts, requiresParensForTupleDistinctCounts, resolveSqlTypeCode, resolveSqlTypeCode, resolveSqlTypeDescriptor, resolveSqlTypeLength, supportsBindAsCallableArgument, supportsBitType, supportsCascadeDelete, supportsCaseInsensitiveLike, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsExpectedLobUsagePattern, supportsFetchClause, supportsFractionalTimestampArithmetic, supportsIfExistsAfterAlterTable, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsAfterTypeName, supportsIfExistsBeforeConstraintName, supportsIfExistsBeforeTableName, supportsIfExistsBeforeTypeName, supportsInsertReturningGeneratedKeys, supportsJdbcConnectionLobCreation, supportsMaterializedLobAccess, supportsNamedParameters, supportsNoColumnsInsert, supportsNoWait, supportsOrderByInSubquery, supportsOrdinalSelectItemReference, supportsParametersInInsertSelect, supportsStandardArrays, supportsStandardCurrentTimestampFunction, supportsSubqueryInSelect, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTemporalLiteralOffset, supportsTemporaryTablePrimaryKey, supportsTemporaryTables, supportsTruncateWithCast, supportsTupleCounts, supportsUnboundedLobLocatorMaterialization, supportsUnionAll, supportsUnionInSubquery, supportsValuesListForInsert, supportsWait, toBooleanValueString, toQuotedIdentifier, toString, transformSelectString, translateDurationField, trimPattern, useFollowOnLocking, useInputStreamToInsertBlob, useMaterializedLobWhenCapacityExceeded

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - DB2Dialect
```
public DB2Dialect()
```
  - DB2Dialect
```
public DB2Dialect(DialectResolutionInfo info)
```
  - DB2Dialect
```
public DB2Dialect(DatabaseVersion version)
```
- Method Detail
  - getMinimumSupportedVersion
```
protected DatabaseVersion getMinimumSupportedVersion()
```
    Description copied from class: Dialect
    
    Get the version of the SQL dialect that is the minimum supported by this implementation.
    
    Overrides:
    
    getMinimumSupportedVersion in class Dialect
  - registerDefaultKeywords
```
protected void registerDefaultKeywords()
```
    Description copied from class: Dialect
    
    Register the reserved words of ANSI-standard SQL as keywords.
    
    Overrides:
    
    registerDefaultKeywords in class Dialect
    
    See Also:
    
    AnsiSqlKeywords
  - getDB2Version
```
public DatabaseVersion getDB2Version()
```
    DB2 LUW Version
  - getDefaultStatementBatchSize
```
public int getDefaultStatementBatchSize()
```
    Description copied from class: Dialect
    
    The default value to use for the configuration property "hibernate.jdbc.batch_size".
    
    Overrides:
    
    getDefaultStatementBatchSize in class Dialect
  - columnType
```
protected String columnType(int sqlTypeCode)
```
    Description copied from class: Dialect
    The database column type name for a given JDBC type code defined in Types or SqlTypes. This default implementation returns the ANSI-standard type name.
    This method may be overridden by concrete Dialects as an alternative to Dialect.registerColumnTypes(TypeContributions, ServiceRegistry) for simple registrations.
    Note that:
    
    Implementations of this method are expected to define a sensible mapping forTypes.NCLOB Types.NCHAR, and Types.NVARCHAR. On some database, these types are simply remapped to CLOB, CHAR, and VARCHAR.
    Mappings for Types.TIMESTAMP and Types.TIMESTAMP_WITH_TIMEZONE should support explicit specification of precision if possible.
    As specified by DdlTypeRegistry.getDescriptor(int), this method never receives Types.LONGVARCHAR, Types.LONGNVARCHAR, nor Types.LONGVARBINARY, which are considered synonyms for their non-LONG counterparts.
    On the other hand, the types SqlTypes.LONG32VARCHAR, SqlTypes.LONG32NVARCHAR, and SqlTypes.LONG32VARBINARY are not synonyms, and implementations of this method must define sensible mappings, for example to database-native TEXT or CLOB types.
    Overrides:
    
    columnType in class Dialect
    
    Parameters:
    
    sqlTypeCode - a SQL type code
    
    Returns:
    
    a column type name, with $l, $p, $s placeholders for length, precision, scale
    
    See Also:
    
    SqlTypes
  - registerColumnTypes
```
protected void registerColumnTypes(TypeContributions typeContributions,
                                   ServiceRegistry serviceRegistry)
```
    Description copied from class: Dialect
    
    Register ANSI-standard column types using the length limits defined by Dialect.getMaxVarcharLength(), Dialect.getMaxNVarcharLength(), and Dialect.getMaxVarbinaryLength().
    This method is always called when a Dialect is instantiated.
    
    Overrides:
    
    registerColumnTypes in class Dialect
  - createUniqueDelegate
```
protected UniqueDelegate createUniqueDelegate()
```
  - getMaxVarcharLength
```
public int getMaxVarcharLength()
```
    Description copied from class: Dialect
    
    The biggest size value that can be supplied as argument to a Types.VARCHAR-like type.
    For longer column lengths, use some sort of text-like type for the column.
    
    Overrides:
    
    getMaxVarcharLength in class Dialect
  - getDefaultDecimalPrecision
```
public int getDefaultDecimalPrecision()
```
    Description copied from class: Dialect
    
    This is the default precision for a generated column mapped to a BigInteger or BigDecimal.
    Usually returns the maximum precision of the database, except when there is no such maximum precision, or the maximum precision is very high.
    
    Overrides:
    
    getDefaultDecimalPrecision in class Dialect
    
    Returns:
    
    the default precision, in decimal digits
  - supportsPredicateAsExpression
```
protected boolean supportsPredicateAsExpression()
```
    Description copied from class: Dialect
    
    Whether a predicate like a > 0 can appear in an expression context, for example, in a select list item.
    
    Overrides:
    
    supportsPredicateAsExpression in class Dialect
  - supportsDistinctFromPredicate
```
public boolean supportsDistinctFromPredicate()
```
    Description copied from class: Dialect
    Does this dialect support some kind of distinct from predicate?
    That is, does it support syntax like:
    ... where FIRST_NAME IS DISTINCT FROM LAST_NAME
    Overrides:
    
    supportsDistinctFromPredicate in class Dialect
    
    Returns:
    
    True if this SQL dialect is known to support some kind of distinct from predicate; false otherwise
  - initializeFunctionRegistry
```
public void initializeFunctionRegistry(FunctionContributions functionContributions)
```
    Description copied from class: Dialect
    Initialize the given registry with any dialect-specific functions.
    Support for certain SQL functions is required, and if the database does not support a required function, then the dialect must define a way to emulate it.
    These required functions include the functions defined by the JPA query language specification:
    
    avg(arg) - aggregate function
    count([distinct ]arg) - aggregate function
    max(arg) - aggregate function
    min(arg) - aggregate function
    sum(arg) - aggregate function
    
    coalesce(arg0, arg1, ...)
    nullif(arg0, arg1)
    
    lower(arg)
    upper(arg)
    length(arg)
    concat(arg0, arg1, ...)
    locate(pattern, string[, start])
    substring(string, start[, length])
    trim([[spec ][character ]from] string)
    
    abs(arg)
    mod(arg0, arg1)
    sqrt(arg)
    
    current date
    current time
    current timestamp
    Along with an additional set of functions defined by ANSI SQL:
    
    any(arg) - aggregate function
    every(arg) - aggregate function
    
    var_samp(arg) - aggregate function
    var_pop(arg) - aggregate function
    stddev_samp(arg) - aggregate function
    stddev_pop(arg) - aggregate function
    
    cast(arg as Type)
    extract(field from arg)
    
    ln(arg)
    exp(arg)
    power(arg0, arg1)
    floor(arg)
    ceiling(arg)
    
    position(pattern in string)
    substring(string from start[ for length])
    overlay(string placing replacement from start[ for length])
    And the following functions for working with java.time types:
    
    local date
    local time
    local datetime
    offset datetime
    instant
    And a number of additional "standard" functions:
    
    left(string, length)
    right(string, length)
    replace(string, pattern, replacement)
    pad(string with length spec[ character])
    
    pi
    log10(arg)
    log(base, arg)
    sign(arg)
    sin(arg)
    cos(arg)
    tan(arg)
    asin(arg)
    acos(arg)
    atan(arg)
    atan2(arg0, arg1)
    round(arg0[, arg1])
    truncate(arg0[, arg1])
    sinh(arg)
    tanh(arg)
    cosh(arg)
    least(arg0, arg1, ...)
    greatest(arg0, arg1, ...)
    degrees(arg)
    radians(arg)
    
    format(datetime as pattern)
    collate(string as collation)
    str(arg) - synonym of cast(a as String)
    ifnull(arg0, arg1) - synonym of coalesce(a, b)
    Finally, the following functions are defined as abbreviations for extract(), and desugared by the parser:
    
    second(arg) - synonym of extract(second from a)
    minute(arg) - synonym of extract(minute from a)
    hour(arg) - synonym of extract(hour from a)
    day(arg) - synonym of extract(day from a)
    month(arg) - synonym of extract(month from a)
    year(arg) - synonym of extract(year from a)
    Note that according to this definition, the second() function returns a floating point value, contrary to the integer type returned by the native function with this name on many databases. Thus, we don't just naively map these HQL functions to the native SQL functions with the same names.
    Overrides:
    
    initializeFunctionRegistry in class Dialect
  - getDropSchemaCommand
```
public String[] getDropSchemaCommand(String schemaName)
```
    Description copied from class: Dialect
    
    Get the SQL command used to drop the named schema.
    
    Overrides:
    
    getDropSchemaCommand in class Dialect
    
    Parameters:
    
    schemaName - The name of the schema to be dropped.
    
    Returns:
    
    The drop commands
  - getFractionalSecondPrecisionInNanos
```
public long getFractionalSecondPrecisionInNanos()
```
    Since we're using seconds_between() and add_seconds(), it makes sense to use seconds as the "native" precision.
    
    Overrides:
    
    getFractionalSecondPrecisionInNanos in class Dialect
    
    Returns:
    
    the precision, specified as a quantity of nanoseconds
    
    See Also:
    
    TemporalUnit.NATIVE
  - timestampdiffPattern
```
public String timestampdiffPattern(TemporalUnit unit,
                                   TemporalType fromTemporalType,
                                   TemporalType toTemporalType)
```
    Description copied from class: Dialect
    
    Obtain a pattern for the SQL equivalent to a timestampdiff() function call. The resulting pattern must contain ?1, ?2, and ?3 placeholders for the arguments.
    
    Overrides:
    
    timestampdiffPattern in class Dialect
    
    Parameters:
    
    unit - the first argument
    
    fromTemporalType - true if the first argument is a timestamp, false if a date
    
    toTemporalType - true if the second argument is
  - timestampdiffPatternV10
```
public static String timestampdiffPatternV10(TemporalUnit unit,
                                             TemporalType fromTemporalType,
                                             TemporalType toTemporalType)
```
  - timestampaddPattern
```
public String timestampaddPattern(TemporalUnit unit,
                                  TemporalType temporalType,
                                  IntervalType intervalType)
```
    Description copied from class: Dialect
    
    Obtain a pattern for the SQL equivalent to a timestampadd() function call. The resulting pattern must contain ?1, ?2, and ?3 placeholders for the arguments.
    
    Overrides:
    
    timestampaddPattern in class Dialect
    
    Parameters:
    
    unit - The unit to add to the temporal
    
    temporalType - The type of the temporal
    
    intervalType - The type of interval to add or null if it's not a native interval
  - appendDateTimeLiteral
```
public void appendDateTimeLiteral(SqlAppender appender,
                                  TemporalAccessor temporalAccessor,
                                  TemporalType precision,
                                  TimeZone jdbcTimeZone)
```
    Description copied from class: Dialect
    
    Append a datetime literal representing the given java.time value to the given SqlAppender.
    
    Overrides:
    
    appendDateTimeLiteral in class Dialect
  - appendDateTimeLiteral
```
public void appendDateTimeLiteral(SqlAppender appender,
                                  Date date,
                                  TemporalType precision,
                                  TimeZone jdbcTimeZone)
```
    Description copied from class: Dialect
    
    Append a datetime literal representing the given Date value to the given SqlAppender.
    
    Overrides:
    
    appendDateTimeLiteral in class Dialect
  - appendDateTimeLiteral
```
public void appendDateTimeLiteral(SqlAppender appender,
                                  Calendar calendar,
                                  TemporalType precision,
                                  TimeZone jdbcTimeZone)
```
    Description copied from class: Dialect
    
    Append a datetime literal representing the given Calendar value to the given SqlAppender.
    
    Overrides:
    
    appendDateTimeLiteral in class Dialect
  - dropConstraints
```
public boolean dropConstraints()
```
    Description copied from class: Dialect
    
    Do we need to drop constraints before dropping tables in this dialect?
    
    Overrides:
    
    dropConstraints in class Dialect
    
    Returns:
    
    True if constraints must be dropped prior to dropping the table; false otherwise.
  - getCreateIndexTail
```
public String getCreateIndexTail(boolean unique,
                                 List<Column> columns)
```
    Description copied from class: Dialect
    
    A string to be appended to the end of the create index command, usually to specify that null values are to be considered distinct.
    
    Overrides:
    
    getCreateIndexTail in class Dialect
  - getSequenceSupport
```
public SequenceSupport getSequenceSupport()
```
    Description copied from class: Dialect
    
    Get the appropriate SequenceSupport for this dialect.
    
    Overrides:
    
    getSequenceSupport in class Dialect
  - getQuerySequencesString
```
public String getQuerySequencesString()
```
    Description copied from class: Dialect
    
    Get the select command used retrieve the names of all sequences.
    
    Overrides:
    
    getQuerySequencesString in class Dialect
    
    Returns:
    
    The select command; or null if sequences are not supported.
  - getSequenceInformationExtractor
```
public SequenceInformationExtractor getSequenceInformationExtractor()
```
    Description copied from class: Dialect
    
    A SequenceInformationExtractor which is able to extract SequenceInformation from the JDBC result set returned when Dialect.getQuerySequencesString() is executed.
    
    Overrides:
    
    getSequenceInformationExtractor in class Dialect
  - getForUpdateString
```
public String getForUpdateString()
```
    Description copied from class: Dialect
    
    Get the string to append to SELECT statements to acquire pessimistic UPGRADE locks for this dialect.
    
    Overrides:
    
    getForUpdateString in class Dialect
    
    Returns:
    
    The appropriate FOR UPDATE clause string.
  - supportsSkipLocked
```
public boolean supportsSkipLocked()
```
    Description copied from class: Dialect
    
    Does this dialect support SKIP_LOCKED timeout.
    
    Overrides:
    
    supportsSkipLocked in class Dialect
    
    Returns:
    
    true if SKIP_LOCKED is supported
  - getForUpdateSkipLockedString
```
public String getForUpdateSkipLockedString()
```
    Description copied from class: Dialect
    
    Retrieves the FOR UPDATE SKIP LOCKED syntax specific to this dialect.
    
    Overrides:
    
    getForUpdateSkipLockedString in class Dialect
    
    Returns:
    
    The appropriate FOR UPDATE SKIP LOCKED clause string.
  - getForUpdateSkipLockedString
```
public String getForUpdateSkipLockedString(String aliases)
```
    Description copied from class: Dialect
    
    Get the FOR UPDATE OF column_list SKIP LOCKED fragment appropriate for this dialect, given the aliases of the columns to be write locked.
    
    Overrides:
    
    getForUpdateSkipLockedString in class Dialect
    
    Parameters:
    
    aliases - The columns to be write locked.
    
    Returns:
    
    The appropriate FOR UPDATE colunm_list SKIP LOCKED clause string.
  - getWriteLockString
```
public String getWriteLockString(int timeout)
```
    Description copied from class: Dialect
    
    Get the string to append to SELECT statements to acquire pessimistic WRITE locks for this dialect.
    Location of the returned string is treated the same as Dialect.getForUpdateString().
    
    Overrides:
    
    getWriteLockString in class Dialect
    
    Parameters:
    
    timeout - in milliseconds, -1 for indefinite wait and 0 for no wait.
    
    Returns:
    
    The appropriate LOCK clause string.
  - getReadLockString
```
public String getReadLockString(int timeout)
```
    Description copied from class: Dialect
    
    Get the string to append to SELECT statements to acquire READ locks for this dialect.
    Location of the returned string is treated the same as Dialect.getForUpdateString().
    
    Overrides:
    
    getReadLockString in class Dialect
    
    Parameters:
    
    timeout - in milliseconds, -1 for indefinite wait and 0 for no wait.
    
    Returns:
    
    The appropriate LOCK clause string.
  - supportsOuterJoinForUpdate
```
public boolean supportsOuterJoinForUpdate()
```
    Description copied from class: Dialect
    
    Does this dialect support FOR UPDATE in conjunction with outer-joined rows?
    
    Overrides:
    
    supportsOuterJoinForUpdate in class Dialect
    
    Returns:
    
    True if outer-joined rows can be locked via FOR UPDATE.
  - supportsExistsInSelect
```
public boolean supportsExistsInSelect()
```
    Description copied from class: Dialect
    
    Does the dialect support an exists statement in the select clause?
    
    Overrides:
    
    supportsExistsInSelect in class Dialect
    
    Returns:
    
    True if exists checks are allowed in the select clause; false otherwise.
  - supportsLockTimeouts
```
public boolean supportsLockTimeouts()
```
    Description copied from class: Dialect
    
    Does this dialect support specifying timeouts when requesting locks.
    
    Overrides:
    
    supportsLockTimeouts in class Dialect
    
    Returns:
    
    True is this dialect supports specifying lock timeouts.
  - requiresCastForConcatenatingNonStrings
```
public boolean requiresCastForConcatenatingNonStrings()
```
    Description copied from class: Dialect
    
    Does this dialect/database require casting of non-string arguments in the concat() function?
    
    Overrides:
    
    requiresCastForConcatenatingNonStrings in class Dialect
    
    Returns:
    
    true if casting using cast() is required
  - getSelectClauseNullString
```
public String getSelectClauseNullString(int sqlType,
                                        TypeConfiguration typeConfiguration)
```
    Description copied from class: Dialect
    
    Given a JDBC type code, return the expression for a literal null value of that type, to use in a select clause.
    The select query will be an element of a UNION or UNION ALL.
    
    Overrides:
    
    getSelectClauseNullString in class Dialect
    
    Parameters:
    
    sqlType - The Types type code.
    
    typeConfiguration - The type configuration
    
    Returns:
    
    The appropriate select clause value fragment.
  - selectNullString
```
public static String selectNullString(int sqlType)
```
  - registerResultSetOutParameter
```
public int registerResultSetOutParameter(CallableStatement statement,
                                         int col)
                                  throws SQLException
```
    Description copied from class: Dialect
    
    Registers a parameter capable of returning a ResultSet by position, either an OUT parameter, or a REF_CURSOR parameter as defined in Java 8.
    
    Overrides:
    
    registerResultSetOutParameter in class Dialect
    
    Parameters:
    
    statement - The callable statement.
    
    col - The bind position at which to register the output param.
    
    Returns:
    
    The number of (contiguous) bind positions used.
    
    Throws:
    
    SQLException - Indicates problems registering the param.
  - getResultSet
```
public ResultSet getResultSet(CallableStatement ps)
                       throws SQLException
```
    Description copied from class: Dialect
    
    Given a callable statement previously processed by Dialect.registerResultSetOutParameter(java.sql.CallableStatement, int), extract the ResultSet from the OUT parameter.
    
    Overrides:
    
    getResultSet in class Dialect
    
    Parameters:
    
    ps - The callable statement.
    
    Returns:
    
    The extracted result set.
    
    Throws:
    
    SQLException - Indicates problems extracting the result set.
  - supportsCommentOn
```
public boolean supportsCommentOn()
```
    Description copied from class: Dialect
    
    Does this dialect support commenting on tables and columns?
    
    Overrides:
    
    supportsCommentOn in class Dialect
    
    Returns:
    
    true if commenting is supported
  - getAlterColumnTypeString
```
public String getAlterColumnTypeString(String columnName,
                                       String columnType,
                                       String columnDefinition)
```
    Description copied from class: Dialect
    
    The fragment of an alter table command which modifies a column type, or null if column types cannot be modified. Often alter column col_name set data type col_type.
    
    Overrides:
    
    getAlterColumnTypeString in class Dialect
    
    Parameters:
    
    columnName - the name of the column
    
    columnType - the new type of the column
    
    columnDefinition - the full column definition
    
    Returns:
    
    a fragment to be appended to alter table
  - supportsAlterColumnType
```
public boolean supportsAlterColumnType()
```
    Description copied from class: Dialect
    
    Does this dialect support modifying the type of an existing column?
    
    Overrides:
    
    supportsAlterColumnType in class Dialect
  - getFallbackSqmMutationStrategy
```
public SqmMultiTableMutationStrategy getFallbackSqmMutationStrategy(EntityMappingType rootEntityDescriptor,
                                                                    RuntimeModelCreationContext runtimeModelCreationContext)
```
    Description copied from class: Dialect
    
    The SqmMultiTableMutationStrategy to use when not specified by QueryEngineOptions.getCustomSqmMultiTableMutationStrategy().
    
    Overrides:
    
    getFallbackSqmMutationStrategy in class Dialect
    
    See Also:
    
    SqmMutationStrategyHelper.resolveStrategy(org.hibernate.mapping.RootClass, org.hibernate.metamodel.mapping.EntityMappingType, org.hibernate.metamodel.mapping.internal.MappingModelCreationProcess)
  - getFallbackSqmInsertStrategy
```
public SqmMultiTableInsertStrategy getFallbackSqmInsertStrategy(EntityMappingType rootEntityDescriptor,
                                                                RuntimeModelCreationContext runtimeModelCreationContext)
```
    Description copied from class: Dialect
    
    The SqmMultiTableInsertStrategy to use when not specified by QueryEngineOptions.getCustomSqmMultiTableInsertStrategy().
    
    Overrides:
    
    getFallbackSqmInsertStrategy in class Dialect
    
    See Also:
    
    SqmMutationStrategyHelper.resolveInsertStrategy(org.hibernate.mapping.RootClass, org.hibernate.metamodel.mapping.EntityMappingType, org.hibernate.metamodel.mapping.internal.MappingModelCreationProcess)
  - supportsCurrentTimestampSelection
```
public boolean supportsCurrentTimestampSelection()
```
    Description copied from class: Dialect
    
    Does this dialect support some way to retrieve the current timestamp value from the database?
    
    Overrides:
    
    supportsCurrentTimestampSelection in class Dialect
    
    Returns:
    
    True if the current timestamp can be retrieved; false otherwise.
  - getCurrentTimestampSelectString
```
public String getCurrentTimestampSelectString()
```
    Description copied from class: Dialect
    
    The command used to retrieve the current timestamp from the database.
    
    Overrides:
    
    getCurrentTimestampSelectString in class Dialect
  - isCurrentTimestampSelectStringCallable
```
public boolean isCurrentTimestampSelectStringCallable()
```
    Description copied from class: Dialect
    
    Is the command returned by Dialect.getCurrentTimestampSelectString() treated as callable?
    Typically, this indicates the use of the JDBC escape syntax.
    
    Overrides:
    
    isCurrentTimestampSelectStringCallable in class Dialect
    
    Returns:
    
    if the Dialect.getCurrentTimestampSelectString() is treated as callable; false otherwise.
  - supportsResultSetPositionQueryMethodsOnForwardOnlyCursor
```
public boolean supportsResultSetPositionQueryMethodsOnForwardOnlyCursor()
```
    Description copied from class: Dialect
    
    Does this dialect support asking the result set its positioning information on forward-only cursors?
    Specifically, in the case of scrolling fetches, Hibernate needs to use ResultSet.isAfterLast() and ResultSet.isBeforeFirst(). Certain drivers do not allow access to these methods for forward-only cursors.
    
    Overrides:
    
    supportsResultSetPositionQueryMethodsOnForwardOnlyCursor in class Dialect
    
    Returns:
    
    True if methods like ResultSet.isAfterLast() and ResultSet.isBeforeFirst() are supported for forward only cursors; false otherwise.
  - supportsLobValueChangePropagation
```
public boolean supportsLobValueChangePropagation()
```
    Description copied from class: Dialect
    Does the dialect support propagating changes to LOB values back to the database? Talking about mutating the internal value of the locator, as opposed to supplying a new locator instance.
    
    For BLOBs, the internal value might be changed by: Blob.setBinaryStream(long), Blob.setBytes(long, byte[]), Blob.setBytes(long, byte[], int, int), or Blob.truncate(long).
    For CLOBs, the internal value might be changed by: Clob.setAsciiStream(long), Clob.setCharacterStream(long), Clob.setString(long, String), Clob.setString(long, String, int, int), or Clob.truncate(long).
    Overrides:
    
    supportsLobValueChangePropagation in class Dialect
    
    Returns:
    
    True if the changes are propagated back to the database; false otherwise.
  - doesReadCommittedCauseWritersToBlockReaders
```
public boolean doesReadCommittedCauseWritersToBlockReaders()
```
    Description copied from class: Dialect
    
    For the underlying database, is READ_COMMITTED isolation implemented by forcing readers to wait for write locks to be released?
    
    Overrides:
    
    doesReadCommittedCauseWritersToBlockReaders in class Dialect
    
    Returns:
    
    True if writers block readers to achieve READ_COMMITTED; false otherwise.
  - supportsTupleDistinctCounts
```
public boolean supportsTupleDistinctCounts()
```
    Description copied from class: Dialect
    
    Does this dialect support count(distinct a,b)?
    
    Overrides:
    
    supportsTupleDistinctCounts in class Dialect
    
    Returns:
    
    True if the database supports counting distinct tuples; false otherwise.
  - contributeTypes
```
public void contributeTypes(TypeContributions typeContributions,
                            ServiceRegistry serviceRegistry)
```
    Description copied from class: Dialect
    
    A callback which allows the Dialect to contribute types.
    
    Overrides:
    
    contributeTypes in class Dialect
    
    Parameters:
    
    typeContributions - Callback to contribute the types
    
    serviceRegistry - The service registry
  - getAggregateSupport
```
public AggregateSupport getAggregateSupport()
```
    Description copied from class: Dialect
    
    How does this dialect support aggregate types like SqlTypes.STRUCT.
    
    Overrides:
    
    getAggregateSupport in class Dialect
  - getCallableStatementSupport
```
public CallableStatementSupport getCallableStatementSupport()
```
    Description copied from class: Dialect
    
    The CallableStatementSupport for this database. Does this database support returning cursors?
    
    Overrides:
    
    getCallableStatementSupport in class Dialect
  - appendBinaryLiteral
```
public void appendBinaryLiteral(SqlAppender appender,
                                byte[] bytes)
```
    Description copied from class: Dialect
    
    Append a binary literal to the given SqlAppender.
    
    Overrides:
    
    appendBinaryLiteral in class Dialect
  - buildSQLExceptionConversionDelegate
```
public SQLExceptionConversionDelegate buildSQLExceptionConversionDelegate()
```
    Description copied from class: Dialect
    An instance of SQLExceptionConversionDelegate for interpreting dialect-specific error or SQLState codes.
    If this method is overridden to return a non-null value, the default SQLExceptionConverter will use the returned SQLExceptionConversionDelegate in addition to the following standard delegates:
    
    a "static" delegate based on the JDBC4-defined SQLException hierarchy, and
    a delegate that interprets SQLState codes as either X/Open or SQL-2003 codes, depending on what is reported by the JDBC driver.
    
    It is strongly recommended that every Dialect implementation override this method, since interpretation of a SQL error is much more accurate when based on the vendor-specific error code, rather than on the SQLState.
    Overrides:
    
    buildSQLExceptionConversionDelegate in class Dialect
    
    Returns:
    
    The SQLExceptionConversionDelegate for this dialect
  - getUniqueDelegate
```
public UniqueDelegate getUniqueDelegate()
```
    Description copied from class: Dialect
    
    Get the UniqueDelegate supported by this dialect
    
    Overrides:
    
    getUniqueDelegate in class Dialect
    
    Returns:
    
    The UniqueDelegate
  - getMaxIdentifierLength
```
public int getMaxIdentifierLength()
```
    Description copied from class: Dialect
    
    What is the maximum identifier length supported by this dialect?
    
    Overrides:
    
    getMaxIdentifierLength in class Dialect
    
    Returns:
    
    The maximum length.
  - getLimitHandler
```
public LimitHandler getLimitHandler()
```
    Description copied from class: Dialect
    
    Obtain a LimitHandler that implements pagination support for Query.setMaxResults(int) and Query.setFirstResult(int).
    
    Overrides:
    
    getLimitHandler in class Dialect
  - supportsNullPrecedence
```
public boolean supportsNullPrecedence()
```
    Description copied from class: Dialect
    
    Does this dialect support nulls first and nulls last?
    
    Overrides:
    
    supportsNullPrecedence in class Dialect
  - getSqlAstTranslatorFactory
```
public SqlAstTranslatorFactory getSqlAstTranslatorFactory()
```
    Description copied from class: Dialect
    
    Return a SqlAstTranslatorFactory specific to this dialect, or null to use the standard translator.
    
    Overrides:
    
    getSqlAstTranslatorFactory in class Dialect
    
    See Also:
    
    StandardSqlAstTranslatorFactory, JdbcEnvironment.getSqlAstTranslatorFactory()
  - getIdentityColumnSupport
```
public IdentityColumnSupport getIdentityColumnSupport()
```
    Description copied from class: Dialect
    
    Get the appropriate IdentityColumnSupport for this dialect.
    
    Overrides:
    
    getIdentityColumnSupport in class Dialect
    
    Returns:
    
    the IdentityColumnSupport
  - supportsInsertReturning
```
public boolean supportsInsertReturning()
```
    Description copied from class: Dialect
    Does this dialect fully support returning arbitrary generated column values after execution of an insert statement, using native SQL syntax?
    Support for identity columns is insufficient here, we require something like:
    
    insert ... returning ...
    select from final table (insert ... )
    Overrides:
    
    supportsInsertReturning in class Dialect
    
    Returns:
    
    true because we can use select ... from new table (insert .... )
    
    See Also:
    
    OnExecutionGenerator.getGeneratedIdentifierDelegate(org.hibernate.id.PostInsertIdentityPersister), InsertReturningDelegate
  - supportsValuesList
```
public boolean supportsValuesList()
```
    Description copied from class: Dialect
    
    Does this dialect support values lists of form VALUES (1), (2), (3)?
    
    Overrides:
    
    supportsValuesList in class Dialect
    
    Returns:
    
    true if values list are supported
  - supportsPartitionBy
```
public boolean supportsPartitionBy()
```
    Description copied from class: Dialect
    
    Does is dialect support partition by?
    
    Overrides:
    
    supportsPartitionBy in class Dialect
  - supportsNonQueryWithCTE
```
public boolean supportsNonQueryWithCTE()
```
    Description copied from class: Dialect
    
    Does this dialect support insert, update, and delete statements with Common Table Expressions (CTEs)?
    
    Overrides:
    
    supportsNonQueryWithCTE in class Dialect
    
    Returns:
    
    true if non-query statements are supported with CTE
  - supportsRecursiveCTE
```
public boolean supportsRecursiveCTE()
```
    Description copied from class: Dialect
    
    Does this dialect/database support recursive CTEs?
    
    Overrides:
    
    supportsRecursiveCTE in class Dialect
    
    Returns:
    
    true if recursive CTEs are supported
  - supportsOffsetInSubquery
```
public boolean supportsOffsetInSubquery()
```
    Description copied from class: Dialect
    Does this dialect support offset in subqueries?
    For example:
    select * from Table1 where col1 in (select col1 from Table2 order by col2 limit 1 offset 1)
    Overrides:
    
    supportsOffsetInSubquery in class Dialect
    
    Returns:
    
    true if it does
  - supportsWindowFunctions
```
public boolean supportsWindowFunctions()
```
    Description copied from class: Dialect
    
    Does this dialect support window functions like row_number() over (..)?
    
    Overrides:
    
    supportsWindowFunctions in class Dialect
    
    Returns:
    
    true if the underlying database supports window functions, false otherwise. The default is false.
  - supportsLateral
```
public boolean supportsLateral()
```
    Description copied from class: Dialect
    
    Does this dialect support the SQL lateral keyword or a proprietary alternative?
    
    Overrides:
    
    supportsLateral in class Dialect
    
    Returns:
    
    true if the underlying database supports lateral, false otherwise. The default is false.
  - appendDatetimeFormat
```
public void appendDatetimeFormat(SqlAppender appender,
                                 String format)
```
    Description copied from class: Dialect
    Translate the given datetime format string from the pattern language defined by Java's DateTimeFormatter to whatever pattern language is understood by the native datetime formatting function for this database (often the to_char() function).
    Since it's never possible to translate every pattern letter sequences understood by DateTimeFormatter, only the following subset of pattern letters is accepted by Hibernate:
    
    G: era
    
    y: year of era
    
    Y: year of week-based year
    
    M: month of year
    
    w: week of week-based year (ISO week number)
    
    W: week of month
    
    E: day of week (name)
    
    e: day of week (number)
    
    d: day of month
    
    D: day of year
    
    a: AM/PM
    
    H: hour of day (24 hour time)
    
    h: hour of AM/PM (12 hour time)
    
    m: minutes
    
    s: seconds
    
    z,Z,x: timezone offset
    
    In addition, punctuation characters and single-quoted literal strings are accepted.
    Appends a pattern accepted by the function that formats dates and times in this dialect to a SQL fragment that is being constructed.
    Overrides:
    
    appendDatetimeFormat in class Dialect
  - translateExtractField
```
public String translateExtractField(TemporalUnit unit)
```
    Description copied from class: Dialect
    
    Return the name used to identify the given field as an argument to the extract() function, or of this dialect's equivalent function.
    This method does not need to handle TemporalUnit.NANOSECOND, TemporalUnit.NATIVE, TemporalUnit.OFFSET, TemporalUnit.DATE, TemporalUnit.TIME, TemporalUnit.WEEK_OF_YEAR, nor TemporalUnit.WEEK_OF_MONTH, which are already desugared by ExtractFunction.
    
    Overrides:
    
    translateExtractField in class Dialect
  - appendBooleanValueString
```
public void appendBooleanValueString(SqlAppender appender,
                                     boolean bool)
```
    Description copied from class: Dialect
    
    Append the SQL literal expression representing the given boolean value to the given SqlAppender.
    
    Overrides:
    
    appendBooleanValueString in class Dialect
    
    Parameters:
    
    appender - The SqlAppender to append the literal expression to
    
    bool - The boolean value
  - extractPattern
```
public String extractPattern(TemporalUnit unit)
```
    Description copied from class: Dialect
    
    Obtain a pattern for the SQL equivalent to an extract() function call. The resulting pattern must contain ?1 and ?2 placeholders for the arguments.
    This method does not need to handle TemporalUnit.NANOSECOND, TemporalUnit.NATIVE, TemporalUnit.OFFSET, TemporalUnit.DATE, TemporalUnit.TIME, TemporalUnit.WEEK_OF_YEAR, or TemporalUnit.WEEK_OF_MONTH, which are already desugared by ExtractFunction.
    
    Overrides:
    
    extractPattern in class Dialect
    
    Parameters:
    
    unit - the first argument
  - getInExpressionCountLimit
```
public int getInExpressionCountLimit()
```
    Description copied from class: Dialect
    
    Return the limit that the underlying database places on the number of elements in an IN predicate. If the database defines no such limits, simply return zero or a number smaller than zero.
    
    Overrides:
    
    getInExpressionCountLimit in class Dialect
    
    Returns:
    
    The limit, or a non-positive integer to indicate no limit.
  - generatedAs
```
public String generatedAs(String generatedAs)
```
    Description copied from class: Dialect
    
    The generated as clause, or similar, for generated column declarations in DDL statements.
    
    Overrides:
    
    generatedAs in class Dialect
    
    Parameters:
    
    generatedAs - a SQL expression used to generate the column value
    
    Returns:
    
    The generated as clause containing the given expression
  - buildIdentifierHelper
```
public IdentifierHelper buildIdentifierHelper(IdentifierHelperBuilder builder,
                                              DatabaseMetaData dbMetaData)
                                       throws SQLException
```
    Description copied from class: Dialect
    The IdentifierHelper indicated by this dialect for handling identifier conversions. Returning null is allowed and indicates that Hibernate should fall back to building a "standard" helper. In the fallback path, any changes made to the IdentifierHelperBuilder during this call will still be incorporated into the built IdentifierHelper.
    The incoming builder will have the following set:
    
    IdentifierHelperBuilder.isGloballyQuoteIdentifiers()
    
    IdentifierHelperBuilder.getUnquotedCaseStrategy() - initialized to UPPER
    
    IdentifierHelperBuilder.getQuotedCaseStrategy() - initialized to MIXED
    
    By default, Hibernate will do the following:
    
    Call IdentifierHelperBuilder.applyIdentifierCasing(DatabaseMetaData)
    Call IdentifierHelperBuilder.applyReservedWords(DatabaseMetaData)
    Applies AnsiSqlKeywords.sql2003() as reserved words
    
    Applies the {#link #sqlKeywords} collected here as reserved words
    
    Applies the Dialect's NameQualifierSupport, if it defines one
    Overrides:
    
    buildIdentifierHelper in class Dialect
    
    Parameters:
    
    builder - A partially-configured IdentifierHelperBuilder.
    
    dbMetaData - Access to the metadata returned from the driver if needed and if available. WARNING: it may be null.
    
    Returns:
    
    The IdentifierHelper instance to use, or null to indicate Hibernate should use its fallback path
    
    Throws:
    
    SQLException - Accessing the DatabaseMetaData can throw it. Just rethrow and Hibernate will handle it.
    
    See Also:
    
    Dialect.getNameQualifierSupport()
  - canDisableConstraints
```
public boolean canDisableConstraints()
```
    Description copied from class: Dialect
    
    Is there some way to disable foreign key constraint checking while truncating tables? (If there's no way to do it, and if we can't batch truncate, we must drop and recreate the constraints instead.)
    
    Overrides:
    
    canDisableConstraints in class Dialect
    
    Returns:
    
    true if there is some way to do it
    
    See Also:
    
    Dialect.getDisableConstraintsStatement(), Dialect.getDisableConstraintStatement(String, String)
  - getDisableConstraintStatement
```
public String getDisableConstraintStatement(String tableName,
                                            String name)
```
    Description copied from class: Dialect
    
    A SQL statement that temporarily disables checking of the given foreign key constraint.
    
    Overrides:
    
    getDisableConstraintStatement in class Dialect
    
    Parameters:
    
    tableName - the name of the table
    
    name - the name of the constraint
  - getEnableConstraintStatement
```
public String getEnableConstraintStatement(String tableName,
                                           String name)
```
    Description copied from class: Dialect
    
    A SQL statement that re-enables checking of the given foreign key constraint.
    
    Overrides:
    
    getEnableConstraintStatement in class Dialect
    
    Parameters:
    
    tableName - the name of the table
    
    name - the name of the constraint
  - getTruncateTableStatement
```
public String getTruncateTableStatement(String tableName)
```
    Description copied from class: Dialect
    
    A SQL statement that truncates the given table.
    
    Overrides:
    
    getTruncateTableStatement in class Dialect
    
    Parameters:
    
    tableName - the name of the table
  - getCreateUserDefinedTypeExtensionsString
```
public String getCreateUserDefinedTypeExtensionsString()
```
    Description copied from class: Dialect
    
    An arbitrary extension to append to the end of the UDT create type command.
    
    Overrides:
    
    getCreateUserDefinedTypeExtensionsString in class Dialect
  - rowId
```
public String rowId(String rowId)
```
    The more "standard" syntax is rid_bit(alias) but here we use alias.rowid.
    There is also an alternative rid() of type bigint, but it cannot be used with partitioning.
    
    Overrides:
    
    rowId in class Dialect
    
    Parameters:
    
    rowId - the name specified by RowId.value(), which is ignored if Dialect.getRowIdColumnString(java.lang.String) is not overridden
  - rowIdSqlType
```
public int rowIdSqlType()
```
    Description copied from class: Dialect
    
    The JDBC type code of the rowid-like pseudo-column which acts as a high-performance row locator.
    
    Overrides:
    
    rowIdSqlType in class Dialect
    
    Returns:
    
    Types.ROWID by default

Constructor	Description
`DB2Dialect()`
`DB2Dialect(DatabaseVersion version)`
`DB2Dialect(DialectResolutionInfo info)`

Class DB2Dialect

Nested Class Summary

Nested classes/interfaces inherited from class org.hibernate.dialect.Dialect

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect

Constructor Summary

Method Summary

Methods inherited from class org.hibernate.dialect.Dialect

Methods inherited from class java.lang.Object

Constructor Detail

DB2Dialect

DB2Dialect

DB2Dialect

Method Detail

getMinimumSupportedVersion

registerDefaultKeywords

getDB2Version

getDefaultStatementBatchSize

columnType

registerColumnTypes

createUniqueDelegate

getMaxVarcharLength

getDefaultDecimalPrecision

supportsPredicateAsExpression

supportsDistinctFromPredicate

initializeFunctionRegistry

getDropSchemaCommand

getFractionalSecondPrecisionInNanos

timestampdiffPattern

timestampdiffPatternV10

timestampaddPattern

appendDateTimeLiteral

appendDateTimeLiteral

appendDateTimeLiteral

dropConstraints

getCreateIndexTail

getSequenceSupport

getQuerySequencesString

getSequenceInformationExtractor

getForUpdateString

supportsSkipLocked

getForUpdateSkipLockedString

getForUpdateSkipLockedString

getWriteLockString

getReadLockString

supportsOuterJoinForUpdate

supportsExistsInSelect

supportsLockTimeouts

requiresCastForConcatenatingNonStrings

getSelectClauseNullString

selectNullString

registerResultSetOutParameter

getResultSet

supportsCommentOn

getAlterColumnTypeString

supportsAlterColumnType

getFallbackSqmMutationStrategy

getFallbackSqmInsertStrategy

supportsCurrentTimestampSelection

getCurrentTimestampSelectString

isCurrentTimestampSelectStringCallable

supportsResultSetPositionQueryMethodsOnForwardOnlyCursor

supportsLobValueChangePropagation

doesReadCommittedCauseWritersToBlockReaders

supportsTupleDistinctCounts

contributeTypes

getAggregateSupport

getCallableStatementSupport

appendBinaryLiteral

buildSQLExceptionConversionDelegate

getUniqueDelegate

getMaxIdentifierLength

getLimitHandler

supportsNullPrecedence

getSqlAstTranslatorFactory

getIdentityColumnSupport

supportsInsertReturning

supportsValuesList

supportsPartitionBy

supportsNonQueryWithCTE