logo  
Google
 

DB2 SQL-Error: -101

SQLState: 54001

Short Description: THE STATEMENT IS TOO LONG OR TOO COMPLEX

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.

 <-  BACK TO INDEX