MQSeries.net :: View topic - DatabaseRetrieve Node

ashritha · Posted: Sun Nov 21, 2010 7:54 am Post subject:

Hi,

I am trying to use the DatabaseRetrieve node for the first time and am having trouble adding query elements into the node properties. I have a bit of a complex query(not too much actually) with joins. I am not able to add these joins. Can anyone please help me how i can add the query elements as per the sql statement below

select a.*, b.language_key, b.MODEL_DESCRIPTION, c.PH_SHORT_DESC, d.PH_SHORT_DESC, e.PH_SHORT_DESC
from etl_stg.bw_material a
join etl_stg.bw_material_desc b
on a.material = b.material
left join etl_stg.bw_product_hier_desc c
on a.PRODUCT_HIERARCHY_1 = c.PRODUCT_HIERARCHY
and b.language_key = c.language_key
left join etl_stg.bw_product_hier_desc d
on a.PRODUCT_HIERARCHY_2 = d.PRODUCT_HIERARCHY
and b.language_key = d.language_key
left join etl_stg.bw_product_hier_desc e
on a.PRODUCT_HIERARCHY_3 = e.PRODUCT_HIERARCHY
and b.language_key = e.language_key
where b.language_key = 'E' and a.etl_upd_ts =TO_TIMESTAMP('10/12/2010 8:18:56.000 PM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM')

I have tried looking into the infocenters and forums but could not find any documentation around this.

Any help is greatly appreciated.

Thanks,
Ayesha