Re: Using regular expression in SQL give error SQLCODE=171 and SQLSTATE=42815

[Charles Wilt <charles.wilt@xxxxxxxxx>]

My 7.2 SQL reference manual doesn't show REGEXP_LIKE...instead it has
REGEXP_INSTR...

Where'd you get the REGEXP_LIKE()?

Charles

On Tue, Feb 7, 2017 at 11:52 AM, Jose Perez <joseenocperez.jp@xxxxxxxxx>
wrote:

> Anyone using regular expression in sql has faced this issue?, I'm trying to
> catch a string pattern inside a string,  the string pattern should be like
> this (it contain 2 dashes and the pattern ###-#######-#) or  it contain the
> pattern I##### or IMP##### using the below sql
>
>  Declare C0 Cursor for
>
>        Select
>
>               IFNULL(REGEXP_SUBSTR(PLDESCB,'I[0-9]{5}'),'N'),
>
>               IFNULL(REGEXP_SUBSTR(PLDESCB,'IMP[0-9]{5}'),'N'),
>
>
> IFNULL(REGEXP_SUBSTR(PLDESCB,'[0-9]{3}-[0-9]{7}-[0-9]{1,}'),'N')
>
>        From   SESSION.T1
>
>        Where
>
>              (REGEXP_MATCH_COUNT(PLDESCB,'-')=2 And
>
>               REGEXP_like(PLDESCB,'[0-9]{3}-[0-9]{7}-[0-9]{1}[^0-9]')) or
>
>               REGEXP_LIKE(PLDESCB,'I[0-9]{5}') OR
>
>               REGEXP_LIKE(PLDESCB,'IMP[0-9]{5}')
>
> but when opening the cursor I'm getting error SQLCODE=171 and
> SQLSTATE=42815
> What Am I doing wrong? if anyone could point me to the right direction I
> will appreciate it.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD