KFAA31224-E
The specification method of a LISTAGG set function is invalid. (reason = aa....aa, query number = bb....bb) (M+J+O)
The specified LISTAGG set function is invalid.
- aa....aa: Cause of the error
-
-
the length of the LISTAGG separator character string exceeds the maximum length of the LISTAGG result character string
The length of the LISTAGG separator character string exceeds the specified maximum length of the LISTAGG result character string. <SQLSTATE:4271A>
-
the value specified as the maximum length of the LISTAGG result character string is outside the valid range
The specified value of the maximum length of the LISTAGG result character string is outside the specifiable range. <SQLSTATE:4271B>
-
the length of the trailing character string to be truncated exceeds the maximum length of the LISTAGG result character string
The length of the truncated string suffix exceeds the specified maximum length of the LISTAGG result character string. <SQLSTATE: 4271C>
-
- bb....bb: Position number of the query that specified the LISTAGG set function
-
For details about query position numbers, see 1.5 Query position numbers.
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Correct the SQL statement.