select adapter service

, ,
1

Hi,
Plz can u convert the following SQL query into webMethods Adapter service

select a.X_SALES_REGION,b.name ALIAS_NAME, c.name Primary_Industry_Name
from tbsie.mv_s_org_ext a, tbsie.mv_s_org_syn b, tbsie.mv_S_INDUST c
where b.OU_ID(+) = a.row_id
and a.X_PR_INDUST_ID = c.row_id(+)

Regards,
Sunil

2

You can either use a select adapter service or a custom SQL adapter service. Review the JDBC documentation for defining such services.