I'm quite new using Datastage,
Give you background ...I'm only using DB2, Lookup and Tranformer for this job. I have number of IF THN ELSE conditions which I have used in my last stage of Transformer and all are working ok.
Only two conditions are not matching against my SQL which i'm running on IBM DataStudio
I''m checking each condition by using constraint the following IF conditoin work ok for required value
The following condition running ok and match again my SQL
Code: Select all
OP_Appt_hrg_Src.PROCEDURE_FLAG = 0 and (OP_Appt_hrg_Src.CARE_PROF_NC_CONSULTANT [1,1] ='N' or OP_Appt_hrg_Src.CARE_PROF_NC_CONSULTANT [1,1] ='M' or OP_Appt_hrg_Src.CARE_PROF_NC_CONSULTANT [1,1] ='H' )
I'm getting less rows
Code: Select all
OP_Appt_hrg_Src.PROCEDURE_FLAG = 0 and (OP_Appt_hrg_Src.CARE_PROF_NC_CONSULTANT [1,1] ='N' or OP_Appt_hrg_Src.CARE_PROF_NC_CONSULTANT [1,1] ='M' or OP_Appt_hrg_Src.CARE_PROF_NC_CONSULTANT [1,1] ='H' OR OP_Appt_hrg_Src.PROVIDERS_REFERENCE_NO = 'NCL')
Many thanks
Farhan