Ansicht
Dokumentation
QRY2241 - SUBSTR format must be SUBSTR(value,offset,length). ( OS/400 )
CL_GUI_FRONTEND_SERVICES - Frontend Services CL_GUI_FRONTEND_SERVICES - Frontend ServicesThis documentation is copyright by IBM.
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
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up rdisp/max_wprun_time - Maximum work process run time
This documentation is copyright by IBM.
Length: 3250 Date: 20240419 Time: 215303 sap01-206 ( 3 ms )