We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

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

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

PERFORM Short Reference   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.
SAP E-Book


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


BAL_S_LOG - Application Log: Log header data   BAL Application Log Documentation  
This documentation is copyright by IBM.

Length: 3231 Date: 20201025 Time: 011826     sap01-206 ( 8 ms )