Hello,

use Datavault 2 for modeling our dataware, all our tables are column organised tables.

all DV tables are append only and  are of this forme:

TABLE SAT1:

hk : binary

load_dts: timestamps

col1.

col2.

...

most of query on DV tables are of this forme:

SELECT
        sat."hk" AS "hk",
        sat."load_dts" AS "load_dts",
        LEAD(sat."load_dts",1,CAST('9999-12-31T00:00:00' AS TIMESTAMP)) OVER ( PARTITION BY sat."hk" ORDER BY sat."load_dts") AS "load_end_dts",

....

FROM SAT1

JOIN T1 on T1.SAT1_hk = SAT1.hk

WHERE ...

the probleme we are facing is that LEAD() make DB2 leave CDE engine.

the RANK() function dont have this probleme

Best regards,