Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
C. A. Dornelles
SQL - SQLCODE's - Códigos positivos
Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF.
SQLCode +304
A VALUE WITH DATA TYPE
data-type1
CANNOT BE ASSIGNED TO A HOST VARIABLE BECAUSE THE VALUE IS NOT WITHIN THE RANGE OF THE HOST VARIABLE IN POSITION
position-number
WITH DATA TYPE
data-type2
Causa
A FETCH or SELECT into a host variable list or structure, position number
position-number
failed because the host variable having data type
data-type2
was not large enough to hold the retrieved value having data type
data-type1
.
Ação do sistema
The FETCH or SELECT could not return the data for the indicated SELECT item, the indicator variable is set to negative two (-2) to indicate a null value returned. Processing continues.
Resposta ao Desenvolvedor
Verify that table definitions are current, and that the host variable has the proper data type. See the explanation for QLCODE -405 for ranges of SQL data types.
SQLSTATE: 01515