replaceAll function

Replace all allows you to replace a pattern from a character string with a replacement character string.

Setup Syntax

CREATE FUNCTION REPLACE_ALL(VARCHAR(255), VARCHAR(255), VARCHAR(255)) RETURNING VARCHAR(255) EXTERNAL NAME 'com.informix.judrs.IfxStrings.replaceAll(String, String String)' language java;
GRANT EXECUTE ON REPLACE_ALL(VARCHAR(255), VARCHAR(255), VARCHAR(255)) TO PUBLIC;

Usage

CREATE TABLE test(a varchar(255));
INSERT INTO test VALUES('I like dogs');
SELECT REPLACE_ALL(a, 'dogs', 'cats') FROM test;
a
I like cats 
1 row(s) retrieved.