Was this helpful?
OpenSQL Limits
OpenSQL Limits
To maintain application portability, your OpenSQL application should observe the limits listed in the following table. Individual host DBMSes may permit values that exceed these.
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
 
Last modified date: 12/14/2023