Ansicht
Dokumentation

SQL0303 - Variable &2 not compatible or value too long. ( OS/400 )

PERFORM Short Reference   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.


Message : SQL0303
Variable &2 not compatible or value too long.

Message Long Text :

Cause . . . . . : A value cannot be assigned to variable &2 because the data types are not compatible or the value is too long.
-- A FETCH, SELECT, CALL, SET, VALUES INTO, GET DIAGNOSTICS, GET DESCRIPTOR, SET DESCRIPTOR or function invocation cannot be performed because the data type of variable &2 is not compatible with the data type of the corresponding value.
-- For SQL routines, the SQL variable may not be long enough for the corresponding list item, or the SQL parameter or RETURNS data type may not be long enough for the output or RETURN value.
-- When selecting a date value, a character variable must be at least 6 bytes for a Julian date, at least 8 bytes for a date in the MDY, YMD, DMY formats, or at least 10 bytes for all other formats.
-- When selecting a time value, a character variable must be at least 8 bytes for a time in the USA format and at least 5 bytes for all other formats.
-- When selecting a timestamp value, a character variable must be at least 19 bytes.
-- If the variable is C NUL-terminated and the program was compiled with *CNULRQD option, then an additional byte is required for the NUL-terminator for date/time values.
-- For GET DIAGNOSTICS ALL, the variable must be varying length character or varying length graphic.
The relative position of the variable in the INTO clause, the SQLDA, or the CALL statement is &1. If the variable name is *N, a descriptor area was specified on a FETCH statement.
Recovery . . . : Ensure that the data types are compatible for each of the corresponding list items. Ensure the variables are defined correctly for date, time, and timestamp values.

Message File : QSQLMSG
Library Message File : QSYS2924


Vendor Master (General Section)   CPI1466 during Backup  
This documentation is copyright by IBM.

Length: 3243 Date: 20240427 Time: 025146     sap01-206 ( 3 ms )