Re: Using SQL, replace all characters less than x'40' in a string with blank

I suspect it's something to do the enabling the REGEX functions from from
the normally ASCII PASE environment to be used in the EBCDIC environment.

It's probably easier and safer to convert any EBCDIC CCSID to Unicode
before doing the REGEX.

Charles

On Wed, Oct 24, 2018 at 10:46 AM Dan <dan27649@xxxxxxxxx> wrote:

Good point. I've sent an email to our sysadmin requesting this. I know
I'm going to be interrogated about why we need a feature described as
"International Components for Unicode" since this particular function
doesn't seem to have any relationship to it, or it at least can be used in
a "non-international, non-unicode" environment like ours.

- Dan

On Tue, Oct 23, 2018 at 4:10 PM Rob Berendt <rob@xxxxxxxxx> wrote:

Dan,

One problem with waiting until you upgrade before adding new LPPs is that
you have to remember to add them BEFORE you load/apply PTF's. If you
carefully follow the upgrade instructions it clearly lays this out.
Another is remembering that you wanted to add this LPP. :-)

--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://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