pushdown functionality

[system]

Give me the idea of pushdown_sql function…

coming thing in where clause throw me error

STG_CUSTOMER.NAME <> (pushdown_sql(‘DS_SAMPLE’, ‘select ODS_CUSTOMER.NAME from ODS_CUSTOMER’))

Pls help…

---

JES (BOB member since 2008-06-16)

[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)

[system]

In addition to Werner’s links, you might want to consider your approach. If you are truly looking for an exclusion of all the entries from one table, then <> is not the operator you want. NOT IN would be one (albeit non efficient) approach, another would be to use a left outer join with a null filter, and a preload cached lookup would be a third.

• Ernie

---

eepjr24 (BOB member since 2005-09-16)

[system]

Thanx…

---

JES (BOB member since 2008-06-16)