Re: Regex not working with regexp_count

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

Works for me on 7.2

On Mon, Nov 4, 2019 at 8:51 AM Daniel Szyndler <Daniel.Szyndler@xxxxxxxxxxx>
wrote:

> Hi,
>
> I have a simple regex I want to use to validate mobile phone numbers:
> ‘^\+?\d+$' – this checks for 0 or 1  ‘+’ followed by any amount of digits
>
> When I test this on various regex websites (regextester.com for example)
> it seems to do the job perfectly.
>
> But when I plug this into my interactive SQL session like so:
> select regexp_count('07777','^\+?\d+$') from SYSIBM/SYSDUMMY1
>
> I get the following error:
>   1 -- The external program or service program returned SQLSTATE 2201S. The
> text message returned from the program is: ????REGEXP_COUNT????^\+?\d+$ .
>
> This SQLSTATE is “Invalid regular expression pattern.”
>
> I’m sure I’m doing something wrong but unsure what. I have read the IBM
> documentation and my syntax seems to be valid (?)
>
> Cheers
>
> ________________________________
>
> Proud partner of The Ageas Bowl.
>
>
> This email has been sent by and on behalf of one or more of Ageas (UK)
> Limited (registered no: 1093301 ), Ageas Insurance Limited (registered no:
> 354568), Ageas Retail Limited (registered no: 1324965), or a subsidiary of
> Ageas (UK) Limited (together “Ageas UK”). Ageas UK companies are registered
> in England and Wales, and each entity’s registered office is Ageas House,
> Hampshire Corporate Park, Templars Way, Eastleigh SO53 3YA.
>
> Ageas Retail Limited is authorised and regulated by the Financial Conduct
> Authority. Financial Services Register Number: 312468.
>
> Ageas Insurance Limited is authorised by the Prudential Regulation
> Authority and regulated by the Financial Conduct Authority and the
> Prudential Regulation Authority. Financial Services Register Number: 202039
>
> This e-mail together with any attachments are intended for the addressee
> only and may be private and confidential. If you are not the intended
> recipient, or the person responsible for delivering it to the intended
> recipient, you must not open any attachments, or copy, disclose,
> distribute, retain or use this e-mail, including any attachments, in any
> way whatsoever; please return it to us immediately using the reply facility
> on e-mail.
>
> Consider the environment and think before you print this email.
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com