Where
concatValues is the name of the user-defined ESQL
function and the following parameters:
- $source/Pager/Text is a field in the source message
- ' Powered by IBM.' is text
The following is the ESQL used for the user-defined ESQL function in
the preceding example:
CREATE FUNCTION concatValues(IN val INTEGER, IN str CHAR) RETURNS CHAR
BEGIN
return str || ' plus int val ' || CAST(val AS CHAR);
END;
You can also use to select user-defined
ESQL functions. The user-defined ESQL functions are located at the end of
the list of ESQL functions.