KFAA31476-E
An error occurred during execution of the scalar function "aa....aa". (details = bb....bb) (M+J+O)
One of the following errors occurred while scalar function aa....aa was executing:
-
The character string returned by scalar function TRANSLATE exceeded the permitted data length for execution results. <SQLSTATE: 22001>
-
The character string returned by scalar function REPLACE exceeded the permitted data length for execution results. <SQLSTATE: 22001>
-
An error occurred during data conversion:
• The target data type is character string data. <SQLSTATE: 22001>
• The target data type is numeric data. <SQLSTATE: 22003>
• The target data type is datetime data. <SQLSTATE: 22018>
-
An overflow error occurred in numeric data. <SQLSTATE: 22003>
-
An overflow error occurred in datetime data. <SQLSTATE: 22008>
-
A division by zero error occurred. <SQLSTATE: 22012>
-
An out-of-range value was specified in the LN scalar function. <SQLSTATE: 2201E>
-
An out-of-range value was specified in the POWER or SQRT scalar function. <SQLSTATE: 2201F>
-
An out-of-range value was specified in a scalar function. <SQLSTATE: 2250H>
- aa....aa:
-
Scalar function name
- bb....bb: Error detail message
-
-
data length insufficient: The returned value cannot be stored due to the limit on the data length for scalar function execution results.
-
division by zero error: A division by zero error occurred.
-
domain error: An out-of-range value was specified in a scalar function.
-
overflow error: An overflow occurred.
-
transform error: An error occurred during data conversion.
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
The following table shows the corrective action to take:
Error detail message
(bb....bb)
Corrective action to take
data length insufficient
Correct the SQL statement to increase the data length for scalar function execution results. If this message was issued when scalar function TRANSLATE was executing, see Rules in TRANSLATE in the manual HADB SQL Reference.
division by zero error
Correct the SQL statement so that the division by zero error will not occur.
For details about the condition that results in a division by zero error, see Scalar Functions in the manual HADB SQL Reference (see the details of the scalar function displayed in place of aa....aa).
domain error
Correct the SQL statement so that an out-of-range value will not be passed to the scalar function.
For details about the value range permitted for the scalar function, see description of the scalar function displayed in place of aa....aa under Scalar Functions in the manual HADB SQL Reference.
overflow error
Correct the SQL statement so that an overflow error will not occur.
transform error
Correct the SQL statement so that the target data can be stored in the data type of the scalar function's execution results.