org.apache.derby.iapi.reference
Interface Limits

public interface Limits

Field Summary

static int	DB2_CHAR_MAXWIDTH
static int	DB2_CONCAT_VARCHAR_LENGTH
static int	DB2_DEFAULT_DECIMAL_PRECISION
static int	DB2_DEFAULT_DECIMAL_SCALE
static int	DB2_JCC_MAX_EXCEPTION_PARAM_LENGTH
static double	DB2_LARGEST_DOUBLE
static double	DB2_LARGEST_NEGATIVE_DOUBLE
static float	DB2_LARGEST_NEGATIVE_REAL
static float	DB2_LARGEST_REAL
static int	DB2_LOB_MAXWIDTH
static int	DB2_LONGVARCHAR_MAXWIDTH
static int	DB2_MAX_CHARACTER_LITERAL_LENGTH
static int	DB2_MAX_COLUMNS_IN_TABLE
static int	DB2_MAX_COLUMNS_IN_VIEW
static int	DB2_MAX_DECIMAL_PRECISION_SCALE DECIMAL type limits
static int	DB2_MAX_ELEMENTS_IN_GROUP_BY
static int	DB2_MAX_ELEMENTS_IN_ORDER_BY
static int	DB2_MAX_ELEMENTS_IN_SELECT_LIST
static int	DB2_MAX_FLOATINGPOINT_LITERAL_LENGTH
static int	DB2_MAX_HEX_LITERAL_LENGTH
static int	DB2_MAX_INDEXES_ON_TABLE Maximum number of indexes on a table
static int	DB2_MAX_PAGE_SIZE
static int	DB2_MAX_TRIGGER_RECURSION Various fixed Limits.
static int	DB2_MIN_COL_LENGTH_FOR_CURRENT_SCHEMA
static int	DB2_MIN_COL_LENGTH_FOR_CURRENT_USER
static int	DB2_MIN_PAGE_SIZE DB2 TABLESPACE page size limits
static double	DB2_SMALLEST_DOUBLE
static double	DB2_SMALLEST_POSITIVE_DOUBLE
static float	DB2_SMALLEST_POSITIVE_REAL
static float	DB2_SMALLEST_REAL REAL/DOUBLE range limits pre DERBY-3398.
static int	DB2_VARCHAR_MAXWIDTH
static int	MAX_BLOB_RETURN_LEN The maximum length of the data returned from the BLOB stored procedures.
static int	MAX_CLOB_RETURN_LEN The maximum length of the data returned from the CLOB stored procedures.
static int	MAX_IDENTIFIER_LENGTH

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_COLUMNS_IN_TABLE

static final int DB2_MAX_COLUMNS_IN_TABLE

See Also:

Constant Field Values

DB2_MAX_COLUMNS_IN_VIEW

static final int DB2_MAX_COLUMNS_IN_VIEW

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_JCC_MAX_EXCEPTION_PARAM_LENGTH

static final int DB2_JCC_MAX_EXCEPTION_PARAM_LENGTH

See Also:

Constant Field Values

MAX_IDENTIFIER_LENGTH

static final int MAX_IDENTIFIER_LENGTH

See Also:

Constant Field Values

DB2_CHAR_MAXWIDTH

static final int DB2_CHAR_MAXWIDTH

See Also:

Constant Field Values

DB2_VARCHAR_MAXWIDTH

static final int DB2_VARCHAR_MAXWIDTH

See Also:

Constant Field Values

DB2_LOB_MAXWIDTH

static final int DB2_LOB_MAXWIDTH

See Also:

Constant Field Values

DB2_LONGVARCHAR_MAXWIDTH

static final int DB2_LONGVARCHAR_MAXWIDTH

See Also:

Constant Field Values

DB2_CONCAT_VARCHAR_LENGTH

static final int DB2_CONCAT_VARCHAR_LENGTH

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_PAGE_SIZE

static final int DB2_MAX_PAGE_SIZE

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_DEFAULT_DECIMAL_SCALE

static final int DB2_DEFAULT_DECIMAL_SCALE

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_LARGEST_REAL

static final float DB2_LARGEST_REAL

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_DOUBLE

static final double DB2_SMALLEST_DOUBLE

See Also:

Constant Field Values

DB2_LARGEST_DOUBLE

static final double DB2_LARGEST_DOUBLE

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