public static class ERXSQLHelper.DB2SQLHelper extends ERXSQLHelper
ERXSQLHelper.ColumnIndex, ERXSQLHelper.CustomTypes, ERXSQLHelper.DB2SQLHelper, ERXSQLHelper.DerbySQLHelper, ERXSQLHelper.EROracleSQLHelper, ERXSQLHelper.FirebirdSQLHelper, ERXSQLHelper.FrontBaseSQLHelper, ERXSQLHelper.H2SQLHelper, ERXSQLHelper.MicrosoftSQLHelper, ERXSQLHelper.MySQLSQLHelper, ERXSQLHelper.NoSQLHelper, ERXSQLHelper.OpenBaseSQLHelper, ERXSQLHelper.OracleSQLHelper, ERXSQLHelper.PostgresqlSQLHelper| Constructor and Description |
|---|
DB2SQLHelper() |
| Modifier and Type | Method and Description |
|---|---|
protected boolean |
canReliablyPerformDistinctWithSortOrderings()
Returns whether or not this database can always perform the a distinct operation
when sort orderings are applied.
|
protected char |
commandSeparatorChar()
This is totally cheating ...
|
protected String |
commandSeparatorString() |
String |
createIndexSQLForEntities(NSArray<EOEntity> entities,
NSArray<String> externalTypesToIgnore) |
String |
limitExpressionForSQL(EOSQLExpression expression,
EOFetchSpecification fetchSpecification,
String sql,
long start,
long end) |
String |
migrationTableName()
Returns the name of the table to use for database migrations.
|
boolean |
reassignExternalTypeForValueTypeOverride(EOAttribute attribute) |
String |
sqlForCreateIndex(String indexName,
String tableName,
ERXSQLHelper.ColumnIndex... columnIndexes)
Returns the SQL expression for creating an index on the given set
of columns
|
String |
sqlForCreateUniqueIndex(String indexName,
String tableName,
ERXSQLHelper.ColumnIndex... columnIndexes)
Returns the SQL expression for creating a unique index on the given set
of columns
|
protected String |
sqlForGetNextValFromSequencedNamed(String sequenceName)
Returns the SQL required to select the next value from the given sequence.
|
protected String |
sqlForSubquery(String subquery,
String alias)
Returns the syntax for using the given query as an aliased subquery in a from-clause.
|
int |
varcharLargeJDBCType()
For DB2, it seems the right thing to do for varcharLarge is to use a Clob column.
|
_groupByOrHavingIndex, _orderByIndex, addGroupByClauseToExpression, addGroupByClauseToExpression, addHavingCountClauseToExpression, appendItemToListString, attributesToFetchForEntity, columnIndexesFromColumnNames, columnNamesFromColumnIndexes, commentPattern, createDependentSchemaSQLForEntities, createIndexSQLForEntities, createSchemaSQLForEntitiesInDatabaseContext, createSchemaSQLForEntitiesInModel, createSchemaSQLForEntitiesInModelAndOptions, createSchemaSQLForEntitiesInModelWithName, createSchemaSQLForEntitiesInModelWithNameAndOptions, createSchemaSQLForEntitiesWithOptions, createSchemaSQLForEntitiesWithOptions, customQueryExpressionHintAsString, defaultOptionDictionary, externalTypeForJDBCType, formatValueForAttribute, getNextValFromSequenceNamed, handleDatabaseException, jdbcTypeForCustomType, maximumElementPerInClause, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, prepareConnectionForSchemaChange, quoteColumnName, readFormatForAggregateFunction, readFormatForAggregateFunction, removeSelectFromExpression, restoreConnectionSettingsAfterSchemaChange, rowCountForFetchSpecification, shouldExecute, shouldPerformDistinctInMemory, splitSQLStatements, splitSQLStatementsFromFile, splitSQLStatementsFromInputStream, sqlExpressionForFetchSpecification, sqlExpressionForFetchSpecification, sqlForCountDistinct, sqlForCreateIndex, sqlForCreateUniqueIndex, sqlForFullTextQuery, sqlForRegularExpressionQuery, sqlWhereClauseStringForKey, varcharLargeColumnWidthprotected String sqlForSubquery(String subquery, String alias)
ERXSQLHelpersqlForSubquery in class ERXSQLHelpersubquery - the subquery to wrapalias - the alias to useprotected String sqlForGetNextValFromSequencedNamed(String sequenceName)
ERXSQLHelpersqlForGetNextValFromSequencedNamed in class ERXSQLHelpersequenceName - the name of the sequencepublic String limitExpressionForSQL(EOSQLExpression expression, EOFetchSpecification fetchSpecification, String sql, long start, long end)
limitExpressionForSQL in class ERXSQLHelperprotected char commandSeparatorChar()
ERXSQLHelpercommandSeparatorChar in class ERXSQLHelperprotected String commandSeparatorString()
commandSeparatorString in class ERXSQLHelperpublic String createIndexSQLForEntities(NSArray<EOEntity> entities, NSArray<String> externalTypesToIgnore)
createIndexSQLForEntities in class ERXSQLHelperpublic String sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
ERXSQLHelpersqlForCreateUniqueIndex in class ERXSQLHelperindexName - the name of the index to createtableName - the name of the containing tablecolumnIndexes - the list of columns to index onpublic String sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
ERXSQLHelpersqlForCreateIndex in class ERXSQLHelperindexName - the name of the index to createtableName - the name of the containing tablecolumnIndexes - the list of columns to index onpublic String migrationTableName()
ERXSQLHelpermigrationTableName in class ERXSQLHelperpublic boolean reassignExternalTypeForValueTypeOverride(EOAttribute attribute)
reassignExternalTypeForValueTypeOverride in class ERXSQLHelperprotected boolean canReliablyPerformDistinctWithSortOrderings()
ERXSQLHelpercanReliablyPerformDistinctWithSortOrderings in class ERXSQLHelperpublic int varcharLargeJDBCType()
varcharLargeJDBCType in class ERXSQLHelperCopyright © 2002 – 2025 Project Wonder.