Re: Regex not working with regexp_count

The regex is right for what you are asking it to do.

My guess would also be CCSID issue.
I'm on 285 and it runs fine for me but if I change my job to CCSID 37 and
run the same thing I get the same error as you.

Does the Host Page on your ACS Session ( right click the session under ACS
configured sessions and select modify to see the host code page) match your
job CCSID?

On a slightly different matter - rather than counting:

values (regexp_count('07777','^\+?\d+$'))

I'd probably substring it out and pass a null indicator to check if it was
valid:

values (regexp_substr('07777','^\+?\d+$'))

regards,
Craig