KFAA31235-E

The specification method of the aa....aa scalar function is invalid.

               aa....aa:

                  Name of the scalar function in which the error occurred

               bb....bb: Cause of the error

                        the identification number is outside the valid range

                        The value of the identification number exceeds the range that can be specified. <SQLSTATE: 4278J>

                        the total number of the types of scalar functions specified in the SQL statement exceeds 1,000

                        The total number of the types of identification numbers for the aa....aa scalar function that can be specified in the SQL statement exceeds 1,000. <SQLSTATE: 4278K>

                        specified position is invalid

                        The aa....aa scalar function is specified in an invalid position. <SQLSTATE: 4278M>

                        the specification of scalar functions that have the same identification number is invalid

                        The specification method of aa....aa scalar functions that have the same identification number is invalid. <SQLSTATE: 4278N>

               cc....cc: Position number of the query that specified aa....aa

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

                  However, if the value of SQLSTATE for bb....bb is 4278K, three asterisks (***) are displayed.

               S:

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

               Action:

                  Check the rules for the scalar function displayed for aa....aa in the manual HADB SQL Reference, and then correct the SQL statement.

                  If bb....bb is the specification of scalar functions that have the same identification number is invalid, take one of the following actions:

                        If aa....aa is RANDOMCURSOR

                        Correct the RANDOMCURSOR scalar functions specified with the same identification number in the SQL statement by using one of the following methods:

                              Specify minimum and maximum values for only one RANDOMCURSOR scalar function (do not specify those values for any other RANDOMCURSOR scalar functions).

                              Do not specify minimum and maximum values for any RANDOMCURSOR scalar functions.

                        If aa....aa is RANDOMROW

                        Correct the RANDOMROW scalar functions specified with the same identification number in the query specification by using one of the following methods:

                              Specify minimum and maximum values for only one RANDOMROW scalar function (do not specify these values for any other RANDOMROW scalar functions).

                              Do not specify minimum and maximum values for any RANDOMROW scalar functions.