Length of an identifier

32 bytes

Length of an embedded SQL statement

8,192 bytes

Columns in a result table

1,024

Columns in a GROUP BY parameter

255

Total length of the columns in a GROUP BY parameter

32,767 bytes

UNION operands in a query expression or SELECT statement

31

Columns in an ORDER BY parameter

254

Total length of the columns in an ORDER BY parameter

32,767 bytes

Value expressions in a query expression

1,024

Table names in a query specification

32

Query specifications in a query expression

32

Dynamic parameters used in a statement

1024

Subqueries and user-defined function invocations in a statement

1024

Number of arguments in user-defined function invocations. The actual limit depends on the data types and the complexity of expressions used in the function invocation.

620