Re: Proposal for New RPG BIF

That's what I said before. It's expensive. Recall the days when the
%TIMESATMP BIF returned the microseconds portion with all zeros?
Well, a colleague of mine "implemented" his solution like this:

exec sql set :myTimestmp = current_timestamp;

Very simple huh? When I showed him the code that was generated, he opened
big eyes and said: "This is crazy!".

I taught him to rather use the QWCCVTDTAPI, and this one is real quick.
It's always a non-bound call to a system program, but this one runs real
faster that a call to SQLROUTE, I believe. :-)

JS

El sáb, 3 ago 2024 a las 10:42, Jon Paris (<jon.paris@xxxxxxxxxxxxxx>)
escribió:

Let's just hope that if RPG implement it they don't use the SQL function!
<grin>

I think a lot of people forget that there is an overhead when calling out
to SQL functions - a quick glance at the generated code shows that there is
often a lot going on.


Jon P.

On Aug 2, 2024, at 11:36 AM, Justin Taylor <jtaylor.0ab@xxxxxxxxx>

wrote:

I changed it to:
gResult = 'A' + %Left( blanks : 10 ) + 'B';
and
EXEC SQL set :gResult = 'A' || space(10) || 'B';

Now gives:
55
7427

46
8771


date: Wed, 31 Jul 2024 14:51:43 -0400

from: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
subject: Re: Proposal for New RPG BIF

Just for fun ...

dcl-s blanks char(40) Inz;
dcl-s x char(30);

x = 'A' + %Left( blanks : 10 ) + 'B';


Jon P.

--
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.

--
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.