Interface Limits


public interface Limits
  • Field Details

    • DB2_MAX_TRIGGER_RECURSION

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

      static final int DB2_MAX_INDEXES_ON_TABLE
      Maximum number of indexes on a table
      See Also:
    • DB2_MAX_COLUMNS_IN_TABLE

      static final int DB2_MAX_COLUMNS_IN_TABLE
      See Also:
    • DB2_MAX_COLUMNS_IN_VIEW

      static final int DB2_MAX_COLUMNS_IN_VIEW
      See Also:
    • DB2_MAX_ELEMENTS_IN_SELECT_LIST

      static final int DB2_MAX_ELEMENTS_IN_SELECT_LIST
      See Also:
    • DB2_MAX_ELEMENTS_IN_GROUP_BY

      static final int DB2_MAX_ELEMENTS_IN_GROUP_BY
      See Also:
    • DB2_MAX_ELEMENTS_IN_ORDER_BY

      static final int DB2_MAX_ELEMENTS_IN_ORDER_BY
      See Also:
    • MAX_IDENTIFIER_LENGTH

      static final int MAX_IDENTIFIER_LENGTH
      See Also:
    • DB2_CHAR_MAXWIDTH

      static final int DB2_CHAR_MAXWIDTH
      See Also:
    • DB2_VARCHAR_MAXWIDTH

      static final int DB2_VARCHAR_MAXWIDTH
      See Also:
    • DB2_LOB_MAXWIDTH

      static final int DB2_LOB_MAXWIDTH
      See Also:
    • DB2_LONGVARCHAR_MAXWIDTH

      static final int DB2_LONGVARCHAR_MAXWIDTH
      See Also:
    • DB2_CONCAT_VARCHAR_LENGTH

      static final int DB2_CONCAT_VARCHAR_LENGTH
      See Also:
    • DB2_MAX_FLOATINGPOINT_LITERAL_LENGTH

      static final int DB2_MAX_FLOATINGPOINT_LITERAL_LENGTH
      See Also:
    • DB2_MAX_CHARACTER_LITERAL_LENGTH

      static final int DB2_MAX_CHARACTER_LITERAL_LENGTH
      See Also:
    • DB2_MAX_HEX_LITERAL_LENGTH

      static final int DB2_MAX_HEX_LITERAL_LENGTH
      See Also:
    • DB2_MIN_COL_LENGTH_FOR_CURRENT_USER

      static final int DB2_MIN_COL_LENGTH_FOR_CURRENT_USER
      See Also:
    • DB2_MIN_COL_LENGTH_FOR_CURRENT_SCHEMA

      static final int DB2_MIN_COL_LENGTH_FOR_CURRENT_SCHEMA
      See Also:
    • DB2_MIN_PAGE_SIZE

      static final int DB2_MIN_PAGE_SIZE
      DB2 TABLESPACE page size limits
      See Also:
    • DB2_MAX_PAGE_SIZE

      static final int DB2_MAX_PAGE_SIZE
      See Also:
    • DB2_MAX_DECIMAL_PRECISION_SCALE

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

      static final int DB2_DEFAULT_DECIMAL_PRECISION
      See Also:
    • DB2_DEFAULT_DECIMAL_SCALE

      static final int DB2_DEFAULT_DECIMAL_SCALE
      See Also:
    • 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:
    • DB2_LARGEST_REAL

      static final float DB2_LARGEST_REAL
      See Also:
    • DB2_SMALLEST_POSITIVE_REAL

      static final float DB2_SMALLEST_POSITIVE_REAL
      See Also:
    • DB2_LARGEST_NEGATIVE_REAL

      static final float DB2_LARGEST_NEGATIVE_REAL
      See Also:
    • DB2_SMALLEST_DOUBLE

      static final double DB2_SMALLEST_DOUBLE
      See Also:
    • DB2_LARGEST_DOUBLE

      static final double DB2_LARGEST_DOUBLE
      See Also:
    • DB2_SMALLEST_POSITIVE_DOUBLE

      static final double DB2_SMALLEST_POSITIVE_DOUBLE
      See Also:
    • DB2_LARGEST_NEGATIVE_DOUBLE

      static final double DB2_LARGEST_NEGATIVE_DOUBLE
      See Also:
    • 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:
    • 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: