ESQL functions

This topic lists the different types of ESQL functions.

All the ESQL functions are described here.

Start of changeAll ESQL functions belong to a schema called SQL and this is particularly useful if you have functions with the same name. For example, if you have created a function called SQRT, you can code:
            /* call my SQRT function  */
 
            SET Variable1 [equals char] SQRT (4); 

            /* call the SQL supplied function */

            SET Variable2 [equals char] SQL.SQRT (144);
End of change

Most of the functions described here impose restrictions on the data types of the arguments that can be passed to the function. If the values passed to the functions do not match the required data types, errors are generated at node configuration time whenever possible. Otherwise runtime errors are generated when the function is evaluated.