SQL - SQLCODE's - Códigos negativos -101


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -101

   
 
  • Causa
    • 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.
  • Ação do sistema
    • DB2 cannot process the statement.
  • Resposta ao Desenvolvedor
    • 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

© Copyright IBM Corp.