R373 – Single line ESQL function found (ignore CopyEntireMessage) (WMB)

Single line ESQL function found (ignore CopyEntireMessage) (WMB)

To improve performance, code that can be inlined (small and not complex) should be considered for in-lining.

For example

SET upperValue = toUpperCase(‘test’);

…

CREATE FUNCTION toUpperCase(IN name CHAR)
RETURNS CHAR BEGIN
RETURN UCASE(name);
END;

Could be refactored to the following

SET upperValue = UCASE(name);