Ignore Null value in the query

SELECT

jd.jobname,jd.applic as Application,jd.nodeid,jd.memname,jd.descript as Description,jd.owner,

jd.cyclicint as Cyclic_Job_Interval,jd.schedtab as Parent_Tabel,

jd.wdaystr as Scheduled_Days,

tr.data_center,tr.start_time,tr.end_time,tr.order_date,

(case when tp.var like '%PARM1%' then tp.varexpr end ) PARM1_VALUE,

(case when tp.var like '%PARM2%' then tp.varexpr end ) PARM2_VALUE

FROM CTRLM1P.CMS_JOBDEF JD,CTRLMEM1P.RUNINFO_HISTORY TR,CTRLM1P.CMS_SETVAR TP

WHERE

jd.jobname=tr.job_mem_name and

jd.jobno=tp.jobno and