Table A-2 lists the maximum and minimum values for databases.

Table A-2 Maximum and minimum values for databases

Item		Minimum value	Maximum value	Units
Length of character data (defined length)	CHAR	1	30,000	Characters (Bytes)
	VARCHAR	1	32,000	Characters (Bytes)
Length of national character data (defined length)	NCHAR	1	15,000	Characters
	NVARCHAR	1	16,000	Characters
Length of mixed character data (defined length)	MCHAR	1	30,000	Bytes
	MVARCHAR	1	32,000	Bytes
Precision of packed decimal	DECIMAL	1	29	Digits
Decimal places for packed decimal	DECIMAL	0	29	Digits
Seconds precision for timestamp data	TIMESTAMP	0	6	Digits
Length of BLOB data		0	2,147,483,647	Bytes
BINARY data length (defined length)		1	2,147,483,647	Bytes
Number of columns in a table		1	30,000	Columns
Number of indexes in a table		0	255	Count
Number of index component columns		1	16	Columns
Number of cluster key component columns		1	16	Columns
Number of RDAREAs for storing table partitions		1	1024	Count
Number of BESs where partitioned tables are placed		1	1024	Count
Total number of literals specified for storage conditions when a row-partitioned table is defined (if storage condition is omitted, 1 is assumed)		1	15,000	Count
Number of tables based on view tables		1	64	Count
Number of columns in a view table		1	30,000	Columns
Number of primary key component columns		1	16	Columns
Number of foreign key component columns		1	16	Columns
Number of foreign keys per table		0	255	Count
Number of foreign keys that reference a single primary key		0	255	Count
Number of check constraints that can be specified per table		0	254	Count
Total number of Boolean operators (AND and OR) and check constraint definitions that can be defined per table (excluding the Boolean operators AND and OR in WHEN search conditions in CASE expressions)		0	254	Count
Identifier length (Applicable to table identifier, column name, data type identifier, index type identifier, attribute name, routine identifier, correlation name, index identifier, cursor name, SQL statement identifier, RDAREA name, embedded variable name, indicator variable name, password, constraint name, condition name, SQL variable name, group ID, query name, trigger identifier, statement label, loop variable name, host identifier, list name, roll name, SQL parameter name)		1	30	Bytes
Row length of FIX table		1	30,000	Bytes
Number of SQL parameters in a procedure		0	30,000	Count
Number of repetition columns		2	30,000	Count
Number of index information files created per server			1
Number of processed rows that can be displayed in messages by the following utilities: pdload pdrorg pdrbal		0	4,294,967,2952	Count

¹ The maximum value depends on specifications such as whether or not plug-ins are used and the number of RDAREAs in the server. If plug-in index delayed batch creation uses a HiRDB file system area, the maximum value is 4,096.

² When the number of processed data items exceeds 4,294,967,295, the displayed row count is reset to 0 and the count starts again from 1.