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


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

   
 
  • Causa
    • THE SECOND OR THIRD ARGUMENT OF THE SUBSTR FUNCTION IS OUT OF RANGE.

      One of the following conditions exists:
      • The second argument of the SUBSTR function is less than 1 or greater than M.
      • The third argument of the SUBSTR function is an integer constant 0 or an expression whose value is less than 0 or greater than M-N+1.
      M is the length of the first argument, if it is of fixed-length, or M is the maximum length of the first argument, if it is of varying-length.
      N is the value of the second argument.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Ensure that the second and third arguments of the SUBSTR function have legal values according the above rules.

      SQLSTATE: 22011

© Copyright IBM Corp.