pushdown functionality

[system]

120×120 10.4 KB

Try this in your where clause: pushdown_sql(‘DB2_Datastore_Name’, ‘table1.col4=‘X’ and table1.col1 = FLOAT(table2.col1) and table2.col3 = 100’) E eepjr24 (BOB member since 2005-09-16)

120×120 10.4 KB

Use a pushdown_sql. pushdown_sql(‘source_ds’, ‘a.key1 = b.key1 and a.key2 = b.key2 and a.key3 = b.key3 and b.Beg_Dt_N = (select max(Beg_Dt_N) from b b2 where a.key1 = b2.key1 and a.key2 = b2.key2 and a.key3 = b2.key3)’) You will want to index b.Beg_Dt_N, either seperately or in a combo index at the end of key1, key2, key3. Ernie eepjr24 (BOB member since 2005-09-16)

---

Werner Daehn (BOB member since 2004-12-17)