Aviso importante


  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos


Volta a página anterior

Volta ao Menu Principal


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