Nonstop Database, HiRDB Version 9 UAP Development Guide
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 |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.