KFAA30421-E

An error occurred while trying to execute scalar function aa....aa.

               The character string returned by scalar function TRANSLATE exceeded the permitted data length for execution results. <SQLSTATE: 22001>

               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: Position number of the query that specified aa....aa

                  For details about query position numbers, see 1.5 Query position numbers.

               cc....cc: Error detail message

                        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.

                        data length insufficient: The returned value cannot be stored due to the limit on the data length for scalar function execution results.

               S:

                  Ignores this SQL statement. Alternatively, the system invalidates this transaction.

               Action:

                  The following table shows the corrective action to take:

                                 Error detail message

                                 (cc....cc)

                                 Corrective action to take

                                 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.

                                 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.

Error detail message (cc....cc)	Corrective action to take
`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.
`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.