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


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 -079

   
 
  • Causa
    • QUALIFIER FOR DECLARED GLOBAL TEMPORARY TABLE table-name MUST BE SESSION, NOT qualifier

      The qualifier for a declared temporary table must be SESSION.
      The DECLARE GLOBAL TEMPORARY TABLE statement defines a new temporary table named table-name with an explicit qualifier of qualifier.
      Specifying a qualifier other than SESSION is not allowed.
  • Ação do sistema
    • The statement was not executed.
  • Resposta ao Desenvolvedor
    • Change the statement in one of the following ways:
      • Change the qualifier to SESSION.
      • Remove the qualifier, and let DB2 default it to SESSION.

      SQLSTATE: 428EK

© Copyright IBM Corp.