Ansicht
Dokumentation

SQL7919 - Data conversion required on FETCH or embedded SELECT. ( OS/400 )

CL_GUI_FRONTEND_SERVICES - Frontend Services   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.


Message : SQL7919
Data conversion required on FETCH or embedded SELECT.

Message Long Text :

Cause . . . . . : Host variable &2 requires conversion. The data retrieved for the FETCH or embedded SELECT statement can not be directly moved to the host variables. The statement ran correctly. Performance, however, would be improved if no data conversion was required. The host variable requires conversion for reason &1.
-- Reason 1 - host variable &2 is a character or graphic string of a different length than the value being retrieved.
-- Reason 2 - host variable &2 is a numeric type that is different than the type of the value being retrieved.
-- Reason 3 - host variable &2 is a C character or C graphic string that is NUL-terminated, the program was compiled with option *CNULRQD specified, and the statement is a multiple-row FETCH.
-- Reason 4 - host variable &2 is a variable length string and the value being retrieved is not.
-- Reason 5 - host variable &2 is not a variable length string and the value being retrieved is.
-- Reason 6 - host variable &2 is a variable length string whose maximum length is different than the maximum length of the variable length value being retrieved.
-- Reason 7 - a data conversion was required on the mapping of the value being retrieved to host variable &2, such as a CCSID conversion.
-- Reason 8 - a DRDA connection was used to get the value being retrieved into host variable &2. The value being retrieved is either null capable or varying-length, is contained in a partial row, or is a derived expression.
-- Reason 10 - the length of host variable &2 is too short to hold a TIME or TIMESTAMP value being retrieved.
-- Reason 11 - host variable &2 is of type DATE, TIME or TIMESTAMP, and the value being retrieved is a character string.
-- Reason 12 - too many host variables were specified and records are blocked. Host variable &2 does not have a corresponding column returned from the query.
-- Reason 13 - a DRDA connection was used for a blocked FETCH and the number of host variables specified in the INTO clause is less than the number of result values in the select list.
-- Reason 14 - a LOB Locator was used and the commitment control level of the process was not *ALL.
Recovery . . . : To get better performance, attempt to use host variables of the same type and length as their corresponding result columns.

Message File : QSQLMSG
Library Message File : QSYS2924


CPI1466 during Backup   PERFORM Short Reference  
This documentation is copyright by IBM.

Length: 3261 Date: 20240426 Time: 225354     sap01-206 ( 3 ms )