Hi,
We have SQL queries written in MWS being utilized through MEC in ST and need to convert the SQL queries into XtendM3 API for MT but not sure if it's efficiently achievable without having performance issues.
However tried through custom API CMS100MI, MDBREADMI but it's creating performance issues.
Sample SQL query trying in XtendM3.
select ORITNO, ORCUNO, ORPOPN, ORALUN, ORMTHC
from MVXJDTA.OCUSIT x with (nolock)
join MVXJDTA.OCHCUS with (nolock)
on OSCONO = x.ORCONO
and OSCUNO = x.ORCUNO
and OSCHL1 = ?
where ORCONO=1
and exists (select * from MVXJDTA.OCUSIT y with (nolock)
where y.ORCONO = x.ORCONO
and y.ORITNO = x.ORITNO
and y.ORCUNO = OSCHL1
and (y.ORPOPN <> x.ORPOPN
or y.ORALUN <> x.ORALUN
or y.ORMTHC <> x.ORMTHC))
Please suggest and share the XtendM3 code if it's already been achieved.
Thanks!
