RE: Regex not working with regexp_count

[Justin Taylor <JUSTIN@xxxxxxxxxxxxx>]

On 7.3, I get 1 as a result.

Is it a CCSID issue?  I'm running 37.  



-----Original Message-----
From: Mark Murphy [mailto:jmarkmurphy@xxxxxxxxx] 
Sent: Wednesday, December 04, 2019 8:29 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Regex not working with regexp_count

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