Item | Min/Max | Limit |
Char length | Max | 240 characters |
Columns in index | Max | 16 columns |
Columns in ORDER BY clause | Max | 16 columns |
Columns in table | Max | 127 columns |
Columns in view | Max | 127 columns |
Columns: total length in GROUP BY clause | Max | 2000 bytes |
Columns: total length in ORDER BY clause | Max | 2000 bytes |
Elements in SELECT list | Max | 127 elements |
Negative float value | Min | Processor-dependent |
Negative float value | Max | Processor-dependent |
Positive float value | Min | Processor-dependent |
Positive float value | Max | Processor-dependent |
Host variables in OpenSQL statement | Max | 256 variables |
Integer value | Min | -2,147,483,648 |
Integer value | Max | +2,147,483,647 |
Predicates in HAVING clause | Max | 50 predicates |
Predicates in WHERE clause | Max | 50 predicates |
Row length (including overhead) | Max | 2000 bytes |
Scalar functions in select list | Max | 127 functions |
Smallint value | Min | -32,768 |
Smallint value | Max | 32,767 |
SQL identifier | Max | 18 characters |
Tables in SQL statement | Max | 15 tables |
User ID | Max | 18 characters |
Varchar length | Max | 2000 characters |