Re: RFE for your perusal

Wait, you don't get to say you wouldn't use a function without a bunch of
extra code to make sure it doesn't fail, and that it isn't a deficiency in
the same thread.

BTW, I use SQL regularly. I am just asking for something that I can insert
into an expression that gives the least surprising answer, won't fail, is
easy to read, and easy to maintain.

A call to the SQL pre-compiler does not fit that requirement because I
cannot insert it into an expression.

%subst() does not provide the least surprising answer because it fails
where all other implementation of the same function in other languages do
not. Or, to avoid that failure I have to jump through hoops which make the
code harder to read and maintain.

On Tue, Jul 30, 2019 at 3:26 PM <dlclark@xxxxxxxxxxxxxxxx> wrote:

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 07/30/2019
02:20:56 PM:

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.

In this case, it is not a deficiency in the compiler. See next
response.


"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 07/30/2019
02:23:10 PM:

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.

This makes sense because SQL functions are database-centric while
RPG/LE functions are program-centric. Meaning: SQL functions are designed
with the understanding that they generally operate on data not yet
available to your program. RPG/LE functions are designed with the
understanding that they operate on data already available to your program.
Thus, when the data is already available to your program, you are
expected to be able to determine the characteristics of that data -- such
as its length. You can't know the length (or other characteristics) of
data you have not yet retrieved from the database.


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