According to the following link, I should be able to execute regexp_like() on our system. We are on V7R3 TR 4.
How do I determine which V7R3 TR # the regexp functions come with?
When I run the following:
..i get the following error..
How do I determine which V7R3 TR # the regexp functions come with?
When I run the following:
Code:
select regex_like(myfield,'[0-9]{3}-[0-9]{3}-[0-9]{2}' from mytable where mykey = 'myvalue'
Code:
Message ID . . . . . . : SQL0204 Message . . . . : REGEX_LIKE in *LIBL type *N not found. Cause . . . . . : REGEX_LIKE in *LIBL type *N was not found. If the member name is *ALL, the table is not partitioned. If this is an ALTER TABLE statement and the type is *N, a constraint or partition was not found. If this is not an ALTER TABLE statement and the type is *N, a function, procedure, trigger or sequence object was not found. If a function was not found, REGEX_LIKE is the service program that contains the function. The function will not be found unless the external name and usage name match exactly. Examine the job log for a message that gives more details on which function name is being searched for and the name that did not match.
Comment