The following table lists limitations on various Database Manager values in . Value Limit Maximum columns in a table 1,012 Maximum columns in a view 5,000 Maximum number of parameters in a stored procedure 90 Maximum indexes on a table 32,767 or storage capacity Maximum tables referenced in an SQL statement or a view storage capacity Maximum elements in a select list 1,012 Maximum predicates in a WHERE or HAVING clause storage capacity Maximum number of columns in a GROUP BY clause 32,677 Maximum number of columns in an ORDER BY clause 1,012 Maximum number of prepared statements storage capacity Maximum declared cursors in a program storage capacity Maximum number of cursors opened at one time storage capacity Maximum number of constraints on a table storage capacity Maximum level of subquery nesting storage capacity Maximum number of subqueries in a single statement storage capacity Maximum number of rows changed in a unit of work storage capacity Maximum constants in a statement storage capacity Maximum depth of cascaded triggers 16