THE SECOND OR THIRD ARGUMENT OF THE SUBSTR FUNCTION IS OUT OF RANGE

Conclusão: 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 do Desenvolvedor: Ensure that the second and third arguments of the SUBSTR function have legal values according the above rules.

SQLSTATE: 22011