Sample CA ADS Function › Function Invocation

Function Invocation

The SELECT clause is used to invoke the function. The first example illustrates a correctly executing function:

SELECT DEFJE01.ASIND (1)
  FROM SYSTEM.TABLE WHERE NAME = 'ASIND'
*+
*+                    USER_FUNC
*+                    ---------
*+   9.0000000000000000E+01
*+
*+ 1 row processed

The second example illustrates a function invocation that results in an error message.

SELECT DEFJE01.ASIND (2)
 FROM SYSTEM.TABLE WHERE NAME = 'ASIND'
*+ Status = -4    SQLSTATE = 38000      Messages follow:
*+ DB001075 C-4M321: Table Procedure ASIND exception 38099 ARG MUST BE <= 1.0