RE: [EXTERNAL] Re: RFE for your perusal

Hi Mark
You say
But I don't really want to call into the database just to have it do basic string handling

My question is - why not?
More and more I am creating SQLRPGLE just so I CAN use SQL functions (like UPPER - which is apparently more efficient)

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Mark Murphy
Sent: Tuesday, July 30, 2019 2:23 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Re: RFE for your perusal

BTW, the SQL substr() works as expected. The RPG %subst() does not. But I don't really want to call into the database just to have it do basic string handling.

On Tue, Jul 30, 2019 at 2:20 PM Mark Murphy <jmarkmurphy@xxxxxxxxx> wrote:

Well I guess that's the difference between us, you would prefer to
write procedures to fix deficiencies in the compiler, I would prefer
the compiler was improved.

On Tue, Jul 30, 2019 at 1:28 PM <dlclark@xxxxxxxxxxxxxxxx> wrote:

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on
07/30/2019
01:09:53 PM:

Real quick: what does this do?

%subst(string: 1: %min(10: %len(string)))

now, what does this do?

%subst(string: 1: 10)

I would actually prefer %left(string: 10), but that is not an option.

You prefer the first? I don't.

Actually, I prefer neither -- if, as you say, either can fail
at execution time.

I also don't see the second as sloppy.

I do -- if it can fail at execution time.

I see that as wasted effort.

I don't -- to prevent failures t execution time.

Here is a solution for you that doesn't require IBM to waste
their time and money changing something that works just fine as it
is...
Create
a service procedure called "fuzzy_subst()" (or something similar) and
then always use that service procedure instead of using %subst()
directly.


Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331





*********************************************************************
************************ This email message and any attachments is
for use only by the named
addressee(s) and may contain confidential, privileged and/or
proprietary information. If you have received this message in error,
please immediately notify the sender and delete and destroy the
message and all copies. All unauthorized direct or indirect use or
disclosure of this message is strictly prohibited. No right to
confidentiality or privilege is waived or lost by any error in transmission.

*********************************************************************
************************
--
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@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com

--
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@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com