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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Nevermind...found it in the predicates section instead of the functions...

Charles

On Tue, Feb 7, 2017 at 12:49 PM, Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

> 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