Ansicht
Dokumentation

QRY2246 - SUBSTR length too large for offset. ( OS/400 )

PERFORM Short Reference   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.


Message : QRY2246
SUBSTR length too large for offset.

Message Long Text :

Cause . . . . . : The length is too large for the offset. Offset and length added together must not be greater than the length of the value + 1.
If the Len column is not shown in the list of fields, press F11 to see the field lengths. Move the cursor to the bottom part of the display to roll the fields up or down.
Offset is the starting character position from the beginning of the value, and length is the number of characters that make up the substring. If length is not specified, the substring will start at the offset and continue to the end of the value. For a bracketed double-byte character set (DBCS) value, offset and length are given in number of bytes rather than number of double-byte characters.
Example: if the value CITY is four characters long, these would be the maximum lengths for possible offsets:
-- SUBSTR(CITY,4,1)
-- SUBSTR(CITY,3,2)
-- SUBSTR(CITY,2,3)
-- SUBSTR(CITY,1,4)
Recovery . . . : Type a correct offset and length.

Message File : QQRYMSG
Library Message File : QSYS2924


TXBHW - Original Tax Base Amount in Local Currency   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.

Length: 3231 Date: 20240416 Time: 230426     sap01-206 ( 2 ms )