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

QRY2241 - SUBSTR format must be SUBSTR(value,offset,length). ( OS/400 )

QRY2241 - SUBSTR format must be SUBSTR(value,offset,length). ( OS/400 )

General Data in Customer Master   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by IBM.
SAP E-Book


Message : QRY2241
SUBSTR format must be SUBSTR(value,offset,length).

Message Long Text :

Cause . . . . . : You specified only one argument or more than three arguments for this function.
The correct substring format is SUBSTR(value,offset,length), where:
-- Value can be any character field from the list of fields at the bottom of the display, any previously defined character result field, a character constant, or a character expression.
-- Offset is the starting character position from the beginning of the value. Offset can be a numeric constant or a numeric expression.
-- Length is the number of characters that make up the substring. Length can be a numeric constant or a numeric expression. 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.
Examples: field LASTNAME contains 'JOHNSON ' and is fixed-length.
-- SUBSTR(LASTNAME,1,4) would give the result of 'JOHN'.
-- SUBSTR(LASTNAME,5,3) would give the result of 'SON'.
-- SUBSTR(LASTNAME,5) would give the result of 'SON '.
-- if LASTNAME was variable-length the result would be 'SON'.
Recovery . . . : Specify the correct format for the substring.

Message File : QQRYMSG
Library Message File : QSYS2924


Vendor Master (General Section)   BAL Application Log Documentation  
This documentation is copyright by IBM.

Length: 3250 Date: 20201025 Time: 014943     sap01-206 ( 20 ms )