Appendix H. Maximum and Minimum HiRDB Values

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

Table H-1 lists the maximum and minimum values for the HiRDB system.

Table H-1 HiRDB maximum and minimum values

ClassificationItemMinimum valueMaximum valueUnit
Database manipulationNumber of retrieval items130,000Tables
Number of update columns130,000
Number of sort columns1255
Number of grouped columns0 or 11255
Number of duplicate locked columns1255
Number of nested logical operations0255
Number of value expressions of IN predicate1255
Number of nested scalar functions0255
Length of character string literal in SQL0255Bytes
Length of national character string literal in SQL0127Characters
Length of mixed character string literal in SQL0255Bytes
Length of one SQL statement12,000Kilobytes
Number of tables that can be specified in one SQL statement164Tables
Number of correlation names that can be specified in one SQL statement065
Number of locked base tables in LOCK statement164
Number of arguments in CALL statement030,000
Row length of work table2632,720Bytes
UAPNumber of SQL statements in one UAP14,095Tables
Number of cursors in one UAP01,023
Number of ? parameters in SQL statement030,000
Number of embedded variables in SQL statement030,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, see the HiRDB Version 8 Installation and Design Guide.