Class DB2400Dialect

  • All Implemented Interfaces:

    public class DB2400Dialect
    extends DB2Dialect
    An SQL dialect for DB2/400. This class provides support for DB2 Universal Database for iSeries, also known as DB2/400.
    • Constructor Detail

      • DB2400Dialect

        public DB2400Dialect()
    • Method Detail

      • supportsSequences

        public boolean supportsSequences()
        Description copied from class: Dialect
        Does this dialect support sequences?
        supportsSequences in class DB2Dialect
        True if sequences supported; false otherwise.
      • supportsLimit

        public boolean supportsLimit()
        Description copied from class: Dialect
        Does this dialect support some form of limiting query results via a SQL clause?
        supportsLimit in class DB2Dialect
        True if this dialect supports some form of LIMIT.
      • getQuerySequencesString

        public java.lang.String getQuerySequencesString()
        Description copied from class: Dialect
        Get the select command used retrieve the names of all sequences.
        getQuerySequencesString in class DB2Dialect
        The select command; or null if sequences are not supported.
        See Also:
      • supportsLimitOffset

        public boolean supportsLimitOffset()
        Description copied from class: Dialect
        Does this dialect's LIMIT support (if any) additionally support specifying an offset?
        supportsLimitOffset in class Dialect
        True if the dialect supports an offset within the limit support.
      • useMaxForLimit

        public boolean useMaxForLimit()
        Description copied from class: Dialect
        Does the LIMIT clause take a "maximum" row number instead of a total number of returned rows?

        This is easiest understood via an example. Consider you have a table with 20 rows, but you only want to retrieve rows number 11 through 20. Generally, a limit with offset would say that the offset = 11 and the limit = 10 (we only want 10 rows at a time); this is specifying the total number of returned rows. Some dialects require that we instead specify offset = 11 and limit = 20, where 20 is the "last" row we want relative to offset (i.e. total number of rows = 20 - 11 = 9)

        So essentially, is limit relative from offset? Or is limit absolute?

        useMaxForLimit in class DB2Dialect
        True if limit is relative from offset; false otherwise.
      • supportsVariableLimit

        public boolean supportsVariableLimit()
        Description copied from class: Dialect
        Does this dialect support bind variables (i.e., prepared statement parameters) for its limit/offset?
        supportsVariableLimit in class DB2Dialect
        True if bind variables can be used; false otherwise.
      • getLimitString

        public java.lang.String getLimitString​(java.lang.String sql,
                                               int offset,
                                               int limit)
        Description copied from class: Dialect
        Given a limit and an offset, apply the limit clause to the query.
        getLimitString in class DB2Dialect
        sql - The query to which to apply the limit.
        offset - The offset of the limit
        limit - The limit of the limit ;)
        The modified query statement with the limit applied.
      • getLimitHandler

        public LimitHandler getLimitHandler()
        Description copied from class: Dialect
        Returns the delegate managing LIMIT clause.
        getLimitHandler in class DB2Dialect
        LIMIT clause delegate.
      • getForUpdateString

        public java.lang.String getForUpdateString()
        Description copied from class: Dialect
        Get the string to append to SELECT statements to acquire locks for this dialect.
        getForUpdateString in class DB2Dialect
        The appropriate FOR UPDATE clause string.