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.

JMHO
Vern

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.

WITH
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-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2019 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].