It occurs to me that there may be one way of using “SQL” - or at least the underlying microcode functions - without changing all the logic. Just change the program to read a logical that converts the packed values to a more efficient format. If there are no decimals then binary is an option, otherwise float or Zoned. No idea how much difference it would make but it might be worth a try since the logical is quick and easy to build.

Jon Paris

On Feb 18, 2015, at 4:39 AM, Jevgeni Astanovski <jevgeniast@xxxxxxxxx> wrote:

With so few specifics of the scenario, the following may be way off the
mark, but as a possibility:

Perhaps the /calculations with packed decimal/ over data that is
apparently /record data/ of /some tables/ could be performed by the SQL?

Regards, Chuck

As I wrote, I have a working functionality written on C. It works fine and fast.
Definitely C++ plus SQL will not be faster as there is a significant
amount of optimization in the current code.
SQL would do nothing more but introduce another language.
For the same price I could (in theory) consolidate all packed decimal
calculations in one module, compile it with C compiler and then bind
together with C++ main. But in my particular case it has absolutely no
sense :-)

This is the Bare Metal Programming IBM i (AS/400 and iSeries) (C400-L) mailing list
To post a message email: C400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].