Nonstop Database, HiRDB Version 9 SQL Reference
Numeric values (other than numeric literals) that are to be specified in an SQL statement must be specified in accordance with the notation rules and restrictions that are applicable to unsigned integers; these notation rules and restrictions are shown in Tables 1-11 and 1-12.
SQL recognizes the following as numeric values (not as numeric literals):
- Sort item specification number (sort item specification number of the ORDER BY clause)
- Length and maximum length (the length and the maximum length of character data)
- Maximum number of resources (total number of tables and indexes used in a program)
- Percentage of unused space (the percentage of unused space specified in table and index definitions)
- Precision (the number of significant digits in decimal data)
- Decimal scaling position (the number of digits following the decimal point in decimal data)
- Data guarantee level (ALTER PROCEDURE, ALTER ROUTINE, ALTER TRIGGER, CREATE PROCEDURE, CREATE TYPE, and CREATE TRIGGER)
- Subscript (for repetition columns)
- Maximum number of elements (in a repetition column)
- Precision of fractional seconds (number of digits to the right of the decimal point in time data)
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.