Sample CA ADS Function › SQL Function Example

SQL Function Example

The first example involves the SQL-invoked function ASIND, which returns the arcsine in degrees of the supplied value. The SQL function is implemented using a CA ADS dialog that invokes the CA ADS built-in function ARCSINE-DEGREES().

The SQL function is provided next:

CREATE FUNCTION DEFJE01.ASIND
  (  ARG               DOUBLE PRECISION)
     RETURNS   DOUBLE PRECISION
     EXTERNAL NAME ASIND
     PROTOCOL ADS
     SYSTEM MODE
     LOCAL WORK AREA 0
     GLOBAL WORK AREA 0
     ;