Interface Limits


  • public interface Limits
    • Field Detail

      • DB2_MAX_TRIGGER_RECURSION

        static final int DB2_MAX_TRIGGER_RECURSION
        Various fixed Limits. DB2 related limits are prefixed with "DB2_".
        See Also:
        Constant Field Values
      • DB2_MAX_INDEXES_ON_TABLE

        static final int DB2_MAX_INDEXES_ON_TABLE
        Maximum number of indexes on a table
        See Also:
        Constant Field Values
      • DB2_MAX_ELEMENTS_IN_SELECT_LIST

        static final int DB2_MAX_ELEMENTS_IN_SELECT_LIST
        See Also:
        Constant Field Values
      • DB2_MAX_ELEMENTS_IN_GROUP_BY

        static final int DB2_MAX_ELEMENTS_IN_GROUP_BY
        See Also:
        Constant Field Values
      • DB2_MAX_ELEMENTS_IN_ORDER_BY

        static final int DB2_MAX_ELEMENTS_IN_ORDER_BY
        See Also:
        Constant Field Values
      • DB2_MAX_FLOATINGPOINT_LITERAL_LENGTH

        static final int DB2_MAX_FLOATINGPOINT_LITERAL_LENGTH
        See Also:
        Constant Field Values
      • DB2_MAX_CHARACTER_LITERAL_LENGTH

        static final int DB2_MAX_CHARACTER_LITERAL_LENGTH
        See Also:
        Constant Field Values
      • DB2_MAX_HEX_LITERAL_LENGTH

        static final int DB2_MAX_HEX_LITERAL_LENGTH
        See Also:
        Constant Field Values
      • DB2_MIN_COL_LENGTH_FOR_CURRENT_USER

        static final int DB2_MIN_COL_LENGTH_FOR_CURRENT_USER
        See Also:
        Constant Field Values
      • DB2_MIN_COL_LENGTH_FOR_CURRENT_SCHEMA

        static final int DB2_MIN_COL_LENGTH_FOR_CURRENT_SCHEMA
        See Also:
        Constant Field Values
      • DB2_MIN_PAGE_SIZE

        static final int DB2_MIN_PAGE_SIZE
        DB2 TABLESPACE page size limits
        See Also:
        Constant Field Values
      • DB2_MAX_DECIMAL_PRECISION_SCALE

        static final int DB2_MAX_DECIMAL_PRECISION_SCALE
        DECIMAL type limits
        See Also:
        Constant Field Values
      • DB2_DEFAULT_DECIMAL_PRECISION

        static final int DB2_DEFAULT_DECIMAL_PRECISION
        See Also:
        Constant Field Values
      • DB2_SMALLEST_REAL

        static final float DB2_SMALLEST_REAL
        REAL/DOUBLE range limits pre DERBY-3398. After that fix, they are only used in soft-upgrade scenarios with older databases.
        See Also:
        Constant Field Values
      • DB2_SMALLEST_POSITIVE_REAL

        static final float DB2_SMALLEST_POSITIVE_REAL
        See Also:
        Constant Field Values
      • DB2_LARGEST_NEGATIVE_REAL

        static final float DB2_LARGEST_NEGATIVE_REAL
        See Also:
        Constant Field Values
      • DB2_SMALLEST_POSITIVE_DOUBLE

        static final double DB2_SMALLEST_POSITIVE_DOUBLE
        See Also:
        Constant Field Values
      • DB2_LARGEST_NEGATIVE_DOUBLE

        static final double DB2_LARGEST_NEGATIVE_DOUBLE
        See Also:
        Constant Field Values
      • MAX_BLOB_RETURN_LEN

        static final int MAX_BLOB_RETURN_LEN
        The maximum length of the data returned from the BLOB stored procedures.

        This value is currently dictated by the maximum length of VARCHAR/VARBINARY, because these are the return types of the stored procedures.

        See Also:
        Constant Field Values
      • MAX_CLOB_RETURN_LEN

        static final int MAX_CLOB_RETURN_LEN
        The maximum length of the data returned from the CLOB stored procedures.

        This value is currently dictated by the maximum length of VARCHAR/VARBINARY, because these are the return types of the stored procedures, and the modified UTF8 encoding used for CLOB data. This threshold value could be higher (equal to MAX_BLOB_RETURN_LEN), but then the procedure fetching data from the CLOB must be rewritten to have more logic.

        For now we use the defensive assumption that all characters are represented by three bytes.

        See Also:
        Constant Field Values