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
Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF.
SQLCode +20007
USE OF OPTIMIZATION HINTS IS DISALLOWED BY A DB2 SUBSYSTEM PARAMETER. THE SPECIAL REGISTER 'OPTIMIZATION HINT' IS SET TO THE DEFAULT VALUE OF BLANKS.
Causa
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
