DB2 Scalar functions - Regular expression scalar functions - www.cadcobol.com.br


Volta ao Menu das scalar functions Volta ao Menu Principal

Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

DB2 Scalar functions - Regular expression scalar functions
Function Description
REGEXP_COUNT Returns a count of the number of times that a regular expression pattern is matched in a string.
REGEXP_EXTRACT Returns one occurrence of a substring of a string that matches the regular expression pattern.
REGEXP_INSTR Returns the starting or ending position of the matched substring, depending on the value of the return_option argument.
REGEXP_LIKE Returns a boolean value indicating if the regular expression pattern is found in a string.
The function can be used only where a predicate is supported.
REGEXP_MATCH_COUNT Returns a count of the number of times that a regular expression pattern is matched in a string.
REGEXP_REPLACE Returns a modified version of the source string where occurrences of the regular expression pattern found in the source string are replaced with the specified replacement string.
REGEXP_SUBSTR Returns one occurrence of a substring of a string that matches the regular expression pattern.


© Copyright IBM Corp.