-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. This SQLCODE is issued for a variety of situations, such as:

  • Start of changeToo many parameter markers are specified. End of change
  • Enablement of parallelism has made the statement too complex.

System action

Db2 cannot process the statement.

Programmer response

Divide the statement into shorter or less complex SQL statements.

If parallelism is enabled for the statement, disable parallelism. You can do that 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