The DB2400Dialect type exposes the following members.

Constructors

  NameDescription
DB2400Dialect

Methods

  NameDescription
AddIdentitySelectToInsert
Generate SQL to get the identifier of an inserted row. If the returned value is not null, the caller will prepare a statement from it, set SQL parameters just as it would for insertSQL, and execute it as a query which is expected to return the identifier of the inserted row. If the returned value is null, the caller will execute insertSQL as an update and then execute IdentitySelectString as a query. The default implementation (in this class) returns nullNothingnullptra null reference (Nothing in Visual Basic).
(Inherited from Dialect.)
AppendLockHint (Inherited from Dialect.)
ApplyLocksToSql (Inherited from Dialect.)
CreateCaseFragment
Create an CaseFragment for this dialect
(Inherited from Dialect.)
CreateOuterJoinFragment
Create an JoinFragment for this dialect
(Inherited from Dialect.)
Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Finalize
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
GetAddForeignKeyConstraintString
(Inherited from Dialect.)
GetAddPrimaryKeyConstraintString
The syntax used to add a primary key constraint to a table
(Inherited from Dialect.)
GetCastTypeName (Inherited from Dialect.)
GetCreateSequenceString
(Inherited from DB2Dialect.)
GetDropForeignKeyConstraintString
The syntax used to drop a foreign key constraint from a table.
(Inherited from Dialect.)
GetDropIndexConstraintString
The syntax used to drop an index constraint from a table.
(Inherited from Dialect.)
GetDropPrimaryKeyConstraintString
The syntax used to drop a primary key constraint from a table.
(Inherited from Dialect.)
GetDropSequenceString
(Inherited from DB2Dialect.)
GetDropTableString
Return SQL needed to drop the named table. May (and should) use some form of "if exists" clause, and cascade constraints.
(Inherited from Dialect.)
GetForUpdateNowaitString (Inherited from Dialect.)
GetForUpdateStringOverloaded.
GetHashCode
Serves as a hash function for a particular type. GetHashCode()()() is suitable for use in hashing algorithms and data structures like a hash table.
(Inherited from Object.)
GetIdentitySelectString (Overrides DB2Dialect..::.GetIdentitySelectString(String, String).)
GetLimitStringOverloaded.
GetSequenceNextValString
(Inherited from DB2Dialect.)
GetType
Gets the Type of the current instance.
(Inherited from Object.)
GetTypeNameOverloaded.
IsQuoted
Checks to see if the name has been quoted.
(Inherited from Dialect.)
MemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Quote
Quotes a name.
(Inherited from Dialect.)
QuoteForAliasName
Quotes a name for being used as a aliasname
(Inherited from Dialect.)
QuoteForColumnName
Quotes a name for being used as a columnname
(Inherited from Dialect.)
QuoteForSchemaName
Quotes a name for being used as a schemaname
(Inherited from Dialect.)
QuoteForTableName
Quotes a name for being used as a tablename
(Inherited from Dialect.)
RegisterColumnTypeOverloaded.
RegisterFunction
(Inherited from Dialect.)
ToString
Returns a String that represents the current Object.
(Inherited from Object.)
UnQuoteOverloaded.

Properties

  NameDescription
AddColumnString
(Inherited from DB2Dialect.)
BindLimitParametersFirst
Does the LIMIT clause come at the start of the SELECT statement rather than at the end?
(Inherited from Dialect.)
BindLimitParametersInReverseOrder
(Inherited from DB2Dialect.)
CascadeConstraintsString
Completely optional cascading drop clause
(Inherited from Dialect.)
CloseQuote
The closing quote for a quoted identifier.
(Inherited from Dialect.)
DefaultProperties
Retrieve a set of default Hibernate properties for this database.
(Inherited from Dialect.)
DropConstraints
(Inherited from DB2Dialect.)
ForUpdateNowaitString
Retrieves the FOR UPDATE NOWAIT syntax specific to this dialect
(Inherited from Dialect.)
ForUpdateOfColumns (Inherited from Dialect.)
ForUpdateString (Inherited from DB2Dialect.)
Functions
Aggregate SQL functions as defined in general. This is a case-insensitive hashtable!
(Inherited from Dialect.)
HasAlterTable
Does this dialect support the ALTER TABLE syntax?
(Inherited from Dialect.)
HasDataTypeInIdentityColumn
Whether this dialect has an identity clause added to the data type or a completely seperate identity data type.
(Inherited from Dialect.)
IdentityColumnString
(Inherited from DB2Dialect.)
IdentityInsertString
(Inherited from DB2Dialect.)
LowercaseFunction
The name of the SQL function that transforms a string to lowercase
(Inherited from Dialect.)
MaxAliasLength (Inherited from Dialect.)
MultipleQueriesSeparator
How we seperate the queries when we use multiply queries.
(Inherited from Dialect.)
NoColumnsInsertString
The keyword used to insert a row without specifying any column values
(Inherited from Dialect.)
NullColumnString
The keyword used to specify a nullable column
(Inherited from Dialect.)
OpenQuote
The opening quote for a quoted identifier.
(Inherited from Dialect.)
QualifyIndexName
Do we need to qualify index names with the schema name?
(Inherited from Dialect.)
SupportsIdentityColumns
(Inherited from DB2Dialect.)
SupportsIfExistsAfterTableName
Does the dialect support the syntax 'drop table NAME if exists'
(Inherited from Dialect.)
SupportsIfExistsBeforeTableName
Does the dialect support the syntax 'drop table if exists NAME'
(Inherited from Dialect.)
SupportsLimit (Overrides DB2Dialect..::.SupportsLimit.)
SupportsLimitOffset (Overrides Dialect..::.SupportsLimitOffset.)
SupportsSequences (Overrides DB2Dialect..::.SupportsSequences.)
SupportsSubSelects
Does this dialect support subselects?
(Inherited from Dialect.)
SupportsUnique
Does this dialect support the UNIQUE column syntax?
(Inherited from Dialect.)
SupportsVariableLimit (Overrides Dialect..::.SupportsVariableLimit.)
TimestampResolutionInTicks
Gives the best resolution that the database can use for storing date/time values, in ticks.
(Inherited from Dialect.)
UseMaxForLimit (Overrides DB2Dialect..::.UseMaxForLimit.)

See Also