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
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM 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 here. If you have questions about this, please contact