This will not work on IBM i, which is the flavor of DB2 the OP is asking about.

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

avgcte as (SELECT AVG(exp1) as avgexp1, AVG(exp2) as avgexp2 FROM table1),
covarcte as (SELECT AVG((exp1 - avgexp1)*(exp2-avgexp2)) as covarvalue FROM
table1, avgcte),
corrcte as (SELECT covarvalue/(STDDEV(exp1)*STDDEV(exp2)) as corrvalue FROM
table1, covarcte)

SELECT * from avgcte, covarcte, corrcte

I can't test this out right now, but it looks like it might work to me.

-Tom Stieger

This thread ...


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

This mailing list archive is Copyright 1997-2020 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].