Ansicht
Dokumentation

QRY1446 - SUBSTR offset or length too large for value. ( OS/400 )

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


Message : QRY1446
SUBSTR offset or length too large for value.

Message Long Text :

Cause . . . . . : The offset or length in one of the SUBSTR functions in this expression is not correct.
The offset must be less than or equal to the length of the value, and the offset and length added together must not be greater than the length of the value + 1. For example, if the length of the value is 8, the offset and length added together can be no greater than 9.
For single-byte character set (SBCS) and double-byte character set (DBCS)-graphic values the offset and length are given in characters. For bracketed DBCS values the offset and length are in bytes.
To find the length of a field from the file, look at the bottom half of the Define Result Fields display. To find the length of a result field, view the field information at the bottom of the Select Records display.
For example, if CHARFLD is a SBCS field with length 10, these examples are valid:
-- SUBSTR(CHARFLD, 3, 2)
-- SUBSTR(CHARFLD, 6)
and these examples are not valid:
-- SUBSTR(CHARFLD, 7, 5)
-- SUBSTR(CHARFLD, 11)
Recovery . . . : Type a correct offset and length for the substring expression. The length may be left blank. If the length is left blank, all characters from the offset to the end of the value are used.

Message File : QQRYMSG
Library Message File : QSYS2924


rdisp/max_wprun_time - Maximum work process run time   General Material Data  
This documentation is copyright by IBM.

Length: 3244 Date: 20240425 Time: 170448     sap01-206 ( 3 ms )