-101   THE STATEMENT IS TOO LONG OR TOO COMPLEX

Explanation

DB2® cannot process the statement because it exceeds the system limits for length or complexity. Enabling parallelism will increase the complexity of the statement.

System action

DB2 cannot process the statement.

Programmer response

Divide the statement into shorter or less complex SQL statements.

If the statement enables parallelism, try disabling parallelism. You may do this by using the DEGREE(1) bind option for static SQL, or by setting the CURRENT DEGREE special register to '1' for dynamic SQL.

SQLSTATE

54001