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


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

   
 
  • Causa
    • INVALID USE OF NULL OR DEFAULT.

      The NULL or DEFAULT keyword is not valid as specified.
      One of the following error situations occurred:
      • The NULL keyword was used in the USING source-table clause of the MERGE statement, but the NULL keyword was not explicitly cast to a supported data type.
      • In a SET assignment-statement statement, DEFAULT was assigned to one of the following objects:
        • An SQL variable or an SQL parameter in an SQL procedure
        • A host variable
        • A parameter marker
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Take one of the following actions:
      • Specify the NULL keyword within a CAST expression when using NULL within the USING VALUES clause of the MERGE statement.
      • Do not assign DEFAULT to an SQL variable or an SQL parameter in an SQL procedure, a host variable, or a parameter marker.

      SQLSTATE: 42608

© Copyright IBM Corp.