Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos - +20007


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 +20007
   
 
  • Causa
    • USE OF OPTIMIZATION HINTS IS DISALLOWED BY A DB2 SUBSYSTEM PARAMETER.
      THE SPECIAL REGISTER 'OPTIMIZATION HINT' IS SET TO THE DEFAULT VALUE OF BLANKS.

      DB2 is not enabled to use optimization hints.
      The special register OPTIMIZATION HINT is set to the default value of BLANKS.
  • Ação do sistema
    • Processing continues normally using the default OPTIMIZATION HINT value.
      The user-specified optimization hints are ignored.
      The access path is determined without the use of hints and processing continues normally.
  • Resposta ao Desenvolvedor
    • Enable the use of OPTIMIZATION HINT by changing the value of OPTIMIZATION HINTS on the DB2 Installation panel DSNTIP4.

      If, after further consideration, you do not want to use an OPTIMIZATION HINT, change or remove the SET CURRENT OPTIMIZATION HINT statement.

      SQLSTATE: 01602