Ansicht
Dokumentation

SQL0138 - Argument &1 of substringing function not valid. ( OS/400 )

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.


Message : SQL0138
Argument &1 of substringing function not valid.

Message Long Text :

Cause . . . . . : Argument 2 or 3 of the SUBSTRING function or argument 2 of the LEFT function is either out of range or is an expression that does not evaluate to an integer.
-- For the SUBSTRING function, argument 2 specifies the position of the first character of the result and argument 3 specifies the length of the result. Argument 2 must be a valid position of the first argument. Argument 3 must not exceed the length of argument 1 between argument 2 and the end of the string.
-- For the LEFT function, argument 2 specifies the length of the result. Argument 2 must not exceed the length of argument 1.
-- If argument 1 is a character string or a binary string, a character is a byte, and if argument 1 is graphic string, a character is a DBCS character.
-- If the argument is *N, then one of the arguments is not valid but the argument number is not known.
Recovery . . . : If the argument is *N, display the previously listed messages in the job log (DSPJOBLOG command) or press F10 (Display messages in job log) from this display to determine which argument is in error. Change one or more of the arguments specified in the SUBSTR function. The INTEGER scalar function may be used to convert the argument into an integer result. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


Addresses (Business Address Services)   BAL Application Log Documentation  
This documentation is copyright by IBM.

Length: 3237 Date: 20240425 Time: 191036     sap01-206 ( 3 ms )