The HiRDB system defines a specific range of acceptable values for each item. This appendix lists the maximum and minimum values allowed.

Table L-1 HiRDB maximum and minimum values

Classification	Item	Minimum value	Maximum value	Unit
Database manipulation	Number of retrieval items	1	30,000	Tables
	Number of update columns	1	30,000
	Number of sort columns	1	255
	Number of grouped columns	0 or 1#1	255
	Number of duplicate locked columns	1	255
	Number of nested logical operations	0	255
	Number of value expressions of IN predicate	1	30,000
	Number of nested scalar functions	0	255
	Length of character string literal in SQL	0	255	Bytes
	Length of national character string literal in SQL	0	127	Characters
	Length of mixed character string literal in SQL	0	255	Bytes
	Length of one SQL statement	1	2,000	Kilobytes
	Number of tables that can be specified in one SQL statement	1	64	Tables
	Number of correlation names that can be specified in one SQL statement	0	65
	Number of locked base tables in LOCK statement	1	64
	Number of arguments in CALL statement	0	30,000
	Row length of work table#2	6	32,720	Bytes
UAP	Number of SQL statements in one UAP	1	4,095	Tables
	Number of cursors in one UAP	0	1,023
	Number of ? parameters in SQL statement	0	30,000
	Number of embedded variables in SQL statement	0	30,000

#1: If the GROUP BY clause is specified, the minimum value is 1. If the HAVING clause is specified without the GROUP BY clause, or if a set function is specified in the SELECT clause, the minimum value is 0.

#2: Some SQL statements require a work table file. For details about work table files, see the HiRDB Version 9 Installation and Design Guide.