Can I ask why my code won't work? It is just using standard DB2 for i
aggregate functions to emulate what those standard statistical function do.
I don't know statistics very well, but a brief look online should me that
my calculations seem to match the standard definitions. DISCLAIMER: EVEN IF
MY CODE DOES WORK I DON'T GUARANTEE IT IS CORRECT.
On your point about looking at DB2 LUW documentation, I agree. Usually
only two things can come of it: confusion as to why something doesn't work
or anger as to why that isn't in DB2 for i yet!
On Tue, Dec 3, 2013 at 2:58 PM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>wrote:
This will not work on IBM i, which is the flavor of DB2 the OP is asking
Documentation for DB2 LUW (Linux-Unix-Windows) is generally not
something I recommend to anyone running on IBM i. It will probably end
up just confusing a person.
On 12/3/2013 3:08 PM, Tom Stieger wrote:
Based on the links for DB2 LUW, the following should get you what youneed.
avgcte as (SELECT AVG(exp1) as avgexp1, AVG(exp2) as avgexp2 FROM
covarcte as (SELECT AVG((exp1 - avgexp1)*(exp2-avgexp2)) as covarvalueFROM
corrcte as (SELECT covarvalue/(STDDEV(exp1)*STDDEV(exp2)) as corrvalue
SELECT * from avgcte, covarcte, corrcte
I can't test this out right now, but it looks like it might work to me.
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives