SVM910 Query Makes JDE Client Slow Response
Hi Experts,
Is it true?
When I try to 'select' query SVM910 below :
select distinct JCUSER,
substr(JCSBMDATE,2,2)"YY",
substr(lpad("JCSBMTIME",6,0),0,2)||':'||
substr(lpad("JCSBMTIME",6,0),3,2)"Job Time",
substr(lpad("JCACTTIME",6,0),0,2)||':'||
substr(lpad("JCACTTIME",6,0),3,2)"Act Time",
substr(lpad("JCSBMTIME",6,0),0,2)-substr(lpad("JCACTTIME",6,0),0,2)"Diff(m)",
JCJOBSTS"Status",JCENHV"Env",
substr(JCFNDFUF2,0,(instr(JCFNDFUF2,'_')-1))"Report"
from svm910.f986110
where jcuser like '%SCHEDUL%'
and JCSBMDATE = 120251 -- 07/09/2020
order by substr(JCSBMDATE,2,2) desc, substr(lpad("JCSBMTIME",6,0),0,2)||':'||
substr(lpad("JCSBMTIME",6,0),3,2) desc
It make the JDE client slow response. 3 times I tried and it happen, so users complain to me.