Re: REGEXP_INSTR range

[Bruce Vining <bruce.vining@xxxxxxxxx>]

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