public Class DB2iDialect

Overrides org.hibernate.dialect.Dialect.getCreateIndexString.

Doc from org.hibernate.dialect.Dialect.getCreateIndexString.

The command used to create an index, usually create index or create unique index.

Parameters

unique:boolean

true if the index is a unique index

Returns:String

The command used to create an index.

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.getCreateIndexTail.

Doc from org.hibernate.dialect.Dialect.getCreateIndexTail.

A string to be appended to the end of the create index command, usually to specify that null values are to be considered distinct.

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.getDB2Version.

Doc from org.hibernate.dialect.DB2Dialect.getDB2Version.

DB2 LUW Version

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.getIdentityColumnSupport.

Doc from org.hibernate.dialect.Dialect.getIdentityColumnSupport.

Get the appropriate IdentityColumnSupport for this dialect.

Returns:IdentityColumnSupport

the IdentityColumnSupport

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.getLimitHandler.

Doc from org.hibernate.dialect.Dialect.getLimitHandler.

Obtain a LimitHandler that implements pagination support for Query#setMaxResults(int) and Query#setFirstResult(int).

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.getQuerySequencesString.

Doc from org.hibernate.dialect.Dialect.getQuerySequencesString.

Get the select command used retrieve the names of all sequences.

Returns:String

The select command; or null if sequences are not supported.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getRowIdColumnString.

Doc from org.hibernate.dialect.Dialect.getRowIdColumnString.

If this dialect requires that the rowid column be declared explicitly, return the DDL column definition.

Returns:String

the DDL column definition, or null if the rowid is an implicit pseudo-column

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.getSequenceSupport.

No support for sequences.

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.getSqlAstTranslatorFactory.

Doc from org.hibernate.dialect.Dialect.getSqlAstTranslatorFactory.

Return a SqlAstTranslatorFactory specific to this dialect, or null to use the standard translator.

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.initializeFunctionRegistry.

Doc from org.hibernate.dialect.Dialect.initializeFunctionRegistry.

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

• 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])

• local date
• local time
• local datetime
• offset datetime
• instant

• left(string, length)
• right(string, length)
• replace(string, pattern, replacement)
• pad(string with length spec[ character])
• repeat(string, times)

• 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)

• 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)

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.rowId.

Doc from org.hibernate.dialect.DB2Dialect.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.

Parameters

rowId:String

Doc from org.hibernate.dialect.Dialect.rowId.

the name specified by org.hibernate.annotations.RowId#value(), which is ignored if getRowIdColumnString is not overridden

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.rowIdSqlType.

Doc from org.hibernate.dialect.Dialect.rowIdSqlType.

The JDBC type code of the rowid-like pseudo-column which acts as a high-performance row locator.

Returns:int

Types#ROWID by default

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.supportsDistinctFromPredicate.

Doc from org.hibernate.dialect.Dialect.supportsDistinctFromPredicate.

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

Returns:boolean

True if this SQL dialect is known to support some kind of distinct from predicate; false otherwise

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.supportsLateral.

Doc from org.hibernate.dialect.Dialect.supportsLateral.

Does this dialect support the SQL lateral keyword or a proprietary alternative?

Returns:boolean

true if the underlying database supports lateral, false otherwise. The default is false.

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.supportsRecursiveCTE.

Doc from org.hibernate.dialect.Dialect.supportsRecursiveCTE.

Does this dialect/database support recursive CTEs?

Returns:boolean

true if recursive CTEs are supported

Annotations

@Override

Overrides org.hibernate.dialect.DB2Dialect.supportsSkipLocked.

Doc from org.hibernate.dialect.Dialect.supportsSkipLocked.

Does this dialect support SKIP_LOCKED timeout.

Returns:boolean

true if SKIP_LOCKED is supported

Annotations

@Override