Top Fields
org.apache.derby.shared.common.reference

public Interface Limits

Field Summary

Modifier and TypeField and Description
public static final int
DB2_CHAR_MAXWIDTH

public static final int
DB2_CONCAT_VARCHAR_LENGTH

public static final int
DB2_DEFAULT_DECIMAL_PRECISION

public static final int
DB2_DEFAULT_DECIMAL_SCALE

public static final double
DB2_LARGEST_DOUBLE

public static final double
DB2_LARGEST_NEGATIVE_DOUBLE

public static final float
DB2_LARGEST_NEGATIVE_REAL

public static final float
DB2_LARGEST_REAL

public static final int
DB2_LOB_MAXWIDTH

public static final int
DB2_LONGVARCHAR_MAXWIDTH

public static final int
DB2_MAX_CHARACTER_LITERAL_LENGTH

public static final int
DB2_MAX_COLUMNS_IN_TABLE

public static final int
DB2_MAX_COLUMNS_IN_VIEW

public static final int
DB2_MAX_DECIMAL_PRECISION_SCALE

DECIMAL type limits

public static final int
DB2_MAX_ELEMENTS_IN_GROUP_BY

public static final int
DB2_MAX_ELEMENTS_IN_ORDER_BY

public static final int
DB2_MAX_ELEMENTS_IN_SELECT_LIST

public static final int
DB2_MAX_FLOATINGPOINT_LITERAL_LENGTH

public static final int
DB2_MAX_HEX_LITERAL_LENGTH

public static final int
DB2_MAX_INDEXES_ON_TABLE

Maximum number of indexes on a table

public static final int
DB2_MAX_PAGE_SIZE

public static final int
DB2_MAX_TRIGGER_RECURSION

Various fixed Limits.

public static final int
DB2_MIN_COL_LENGTH_FOR_CURRENT_SCHEMA

public static final int
DB2_MIN_COL_LENGTH_FOR_CURRENT_USER

public static final int
DB2_MIN_PAGE_SIZE

DB2 TABLESPACE page size limits

public static final double
DB2_SMALLEST_DOUBLE

public static final double
DB2_SMALLEST_POSITIVE_DOUBLE

public static final float
DB2_SMALLEST_POSITIVE_REAL

public static final float
DB2_SMALLEST_REAL

REAL/DOUBLE range limits pre DERBY-3398.

public static final int
DB2_VARCHAR_MAXWIDTH

public static final int
MAX_BLOB_RETURN_LEN

The maximum length of the data returned from the BLOB stored procedures.

public static final int
MAX_CLOB_RETURN_LEN

The maximum length of the data returned from the CLOB stored procedures.

public static final int
MAX_IDENTIFIER_LENGTH

Field Detail

DB2_CHAR_MAXWIDTHback to summary
public static final int DB2_CHAR_MAXWIDTH
DB2_CONCAT_VARCHAR_LENGTHback to summary
public static final int DB2_CONCAT_VARCHAR_LENGTH
DB2_DEFAULT_DECIMAL_PRECISIONback to summary
public static final int DB2_DEFAULT_DECIMAL_PRECISION
DB2_DEFAULT_DECIMAL_SCALEback to summary
public static final int DB2_DEFAULT_DECIMAL_SCALE
DB2_LARGEST_DOUBLEback to summary
public static final double DB2_LARGEST_DOUBLE
DB2_LARGEST_NEGATIVE_DOUBLEback to summary
public static final double DB2_LARGEST_NEGATIVE_DOUBLE
DB2_LARGEST_NEGATIVE_REALback to summary
public static final float DB2_LARGEST_NEGATIVE_REAL
DB2_LARGEST_REALback to summary
public static final float DB2_LARGEST_REAL
DB2_LOB_MAXWIDTHback to summary
public static final int DB2_LOB_MAXWIDTH
DB2_LONGVARCHAR_MAXWIDTHback to summary
public static final int DB2_LONGVARCHAR_MAXWIDTH
DB2_MAX_CHARACTER_LITERAL_LENGTHback to summary
public static final int DB2_MAX_CHARACTER_LITERAL_LENGTH
DB2_MAX_COLUMNS_IN_TABLEback to summary
public static final int DB2_MAX_COLUMNS_IN_TABLE
DB2_MAX_COLUMNS_IN_VIEWback to summary
public static final int DB2_MAX_COLUMNS_IN_VIEW
DB2_MAX_DECIMAL_PRECISION_SCALEback to summary
public static final int DB2_MAX_DECIMAL_PRECISION_SCALE

DECIMAL type limits

DB2_MAX_ELEMENTS_IN_GROUP_BYback to summary
public static final int DB2_MAX_ELEMENTS_IN_GROUP_BY
DB2_MAX_ELEMENTS_IN_ORDER_BYback to summary
public static final int DB2_MAX_ELEMENTS_IN_ORDER_BY
DB2_MAX_ELEMENTS_IN_SELECT_LISTback to summary
public static final int DB2_MAX_ELEMENTS_IN_SELECT_LIST
DB2_MAX_FLOATINGPOINT_LITERAL_LENGTHback to summary
public static final int DB2_MAX_FLOATINGPOINT_LITERAL_LENGTH
DB2_MAX_HEX_LITERAL_LENGTHback to summary
public static final int DB2_MAX_HEX_LITERAL_LENGTH
DB2_MAX_INDEXES_ON_TABLEback to summary
public static final int DB2_MAX_INDEXES_ON_TABLE

Maximum number of indexes on a table

DB2_MAX_PAGE_SIZEback to summary
public static final int DB2_MAX_PAGE_SIZE
DB2_MAX_TRIGGER_RECURSIONback to summary
public static final int DB2_MAX_TRIGGER_RECURSION

Various fixed Limits. DB2 related limits are prefixed with "DB2_".

DB2_MIN_COL_LENGTH_FOR_CURRENT_SCHEMAback to summary
public static final int DB2_MIN_COL_LENGTH_FOR_CURRENT_SCHEMA
DB2_MIN_COL_LENGTH_FOR_CURRENT_USERback to summary
public static final int DB2_MIN_COL_LENGTH_FOR_CURRENT_USER
DB2_MIN_PAGE_SIZEback to summary
public static final int DB2_MIN_PAGE_SIZE

DB2 TABLESPACE page size limits

DB2_SMALLEST_DOUBLEback to summary
public static final double DB2_SMALLEST_DOUBLE
DB2_SMALLEST_POSITIVE_DOUBLEback to summary
public static final double DB2_SMALLEST_POSITIVE_DOUBLE
DB2_SMALLEST_POSITIVE_REALback to summary
public static final float DB2_SMALLEST_POSITIVE_REAL
DB2_SMALLEST_REALback to summary
public 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.

DB2_VARCHAR_MAXWIDTHback to summary
public static final int DB2_VARCHAR_MAXWIDTH
MAX_BLOB_RETURN_LENback to summary
public 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.

MAX_CLOB_RETURN_LENback to summary
public 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.

MAX_IDENTIFIER_LENGTHback to summary
public static final int MAX_IDENTIFIER_LENGTH