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


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

   
 
  • Causa
    • THE TOTAL LENGTH OF THE CURRENT PATH SPECIAL REGISTER CANNOT EXCEED 254 CHARACTERS.

      The CURRENT PATH special register is defined as a VARCHAR(254).
      The content of the string includes each schema name delimited with double quotes and separated from the next schema name by a comma.
      The total length of the string of all schema names in the CURRENT PATH cannot exceed 254 characters.
      A SET CURRENT PATH statement causing this message would exceed this limit.
  • Ação do sistema
    • The statement is not executed.
  • Resposta ao Desenvolvedor
    • Remove schema names to reduce the total length to fit the 254 character maximum length.
      If all the schema names are required, it may be necessary to consolidate some user-defined functions so that fewer schema names are required for the CURRENT PATH.

      SQLSTATE: 42907

© Copyright IBM Corp.