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


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 -096
   
 
  • Causa
    • VARIABLE variable-name DOES NOT EXIST OR IS NOT SUPPORTED BY THE SERVER AND A DEFAULT VALUE WAS NOT PROVIDED

      For a global variable, the variable does not exist at this server.
      For a built-in session global variable, the GETVARIABLE function was invoked.
    • If the qualifier is SESSION, a user-defined variable with the specified name has not been set by the connection or signon exit routine.
    • If the qualifier is SYSIBM, the server does not support a built-in session variable with name that was specified.
    variable-name
    The name of the variable.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • For a global variable, create the variable at this server using the CREATE VARIABLE statement.
      For a built-in session global variable, change the invocation of the function to specify a default value for variable-name, or specify a variable that is supported at the server.

      SQLSTATE: 42704

© Copyright IBM Corp.