| Parameter | Value |
|---|---|
| Maximum SQL text size per request. This includes SQL request text, USING data, and parcel overhead. |
1 MB |
| Maximum request message size. The message includes SQL request text, USING data, and parcel overhead. | 7 MB |
| Maximum number of entries in an IN list. There is no fixed limit on the number of entries in an IN list; however, other limits, such as the maximum SQL text size, place a request-specific upper bound on this number. |
Unlimited |
| Maximum SQL activity count size. | 8 bytes |
| Maximum number of tables and single-table views that can be joined per query block. | 128 |
| Maximum number of partitions for a join operation. | 50 |
| Maximum number of subquery nesting levels per query. | 64 |
| Maximum number of tables or single-table views that can be referenced per subquery. | 128 |
| Maximum number of fields in a USING row descriptor. | 2,536 |
| Maximum number of bytes in USING data. This value does not include Smart LOB (SLOB) data. | 1,040,000 |
| Maximum number of open cursors per embedded SQL program. | 16 |
| Maximum SQL text response size. | 1 MB |
| Maximum number of columns per DML request ORDER BY clause. | 64 |
| Maximum number of columns per DML request GROUP BY clause. | 64 |
| Maximum number of fields in a CONSTANT row. | 32,768 |