Re: REGEXP_INSTR range

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Bruce,

Good catch! Unfortunately, the actual data being queried is a long 
string starting with

"- - - - - - - - - - - -  CONNECTION"

so it's (probably) just a coincidence.  I hope.  Otherwise the 
documentation is misleading.

Funny while waiting to fall asleep last night, I was wondering if it was 
supposed to be a tilde ('~') instead of a hyphen ('-'), but as you note, 
the hyphen appears to be the correct character to indicate a range.


On 8/14/2021 3:30 AM, Bruce Vining wrote:
> Peter,
>
> First a disclaimer -- I have never used this function so could be way off.
> But the '-' used in the expression does just happen to be x'60' in for
> instance CCSID 37.  Your use of the range directing '-' appears to be
> correct, but I just hate coincidences like this...
>
> Again this might be a totally misleading reply to your query.
>
>
>
> On Fri, Aug 13, 2021 at 7:59 PM Peter Dow <petercdow@xxxxxxxxx> wrote:
>
> > I'm trying to locate rows in a table that have any character in a
> > particular field with a value less than x'40'.
> >
> > WHERE REGEXP_INSTR(LOGTEXT,'[\x00-\x3f]') > 0
> >
> > Keeps finding records with x'60' in the field.
> >
> > I concocted the regex pattern from what I read on this page:
> >
> >
> > https://www.ibm.com/docs/en/i/7.3?topic=predicates-regexp-like-predicate#rbafzregexp_like__regexp_likecontrol
> >
> > but apparently I don't understand it.  What am I doing wrong?
> >
> > --
> > *Peter Dow* /
> > Dow Software Services, Inc.
> > 909 793-9050
> > petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
> > pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com