Decode in App Engine SQL Step
edited May 29, 2019 8:26AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered ✓
Hi, in an application engine Update sql statement step,two of the fields have the following decoded values. Can you please change the following conditions to "CASE" so that I understand how exactly these values are being set?
COMPRATE = DECODE(%Bind(JOB_PER_AET.EXIST),'Y',DECODE(%Bind(JOB_UPD_AET.EMPL_RCD) ,66 ,.001 , %Bind(JOB_PER_AET.COMPRATE) ),COMPRATE)
DEPTID = DECODE( %Bind(JOB_UPD_AET.EMPL_RCD) ,66 ,'ACTIVE' , DECODE( %Bind(JOB_PER_AET.EXIST),'Y', DECODE( %Bind(JOB_PER_AET.DEPTID), ' ' ,DEPTID,%Bind(JOB_VAL_AET.DEPTID) ), DEPTID))
Thank you,
0