DSXchange

Done! Thanks for your help
Then on next Transformer Stage I sed like that Got the Age
Regards
F

Sorry, I should 've put the format.
The type of the field is "TIMESTAMP" AND VALUE keeps like
I hope it makese sense

To calcuate Age I simply thinking to do following ....CurrenDate() - DOB
Appreciate your advise
Regards
Farhan

I want to calcuate the current AGE. I have used the function YearFromDate(DOB) but it doesn't like that I think because the field type is timestamp, so i thought first convert into into Date so I tried like : but no success again YearFromDate(TimetFromTimestamp(.BIRTH_DTTM)) But not working there is...

Thanks a lot first Time I have used this forum quite good

Kind Regards
Farhan

I've run the distinct on that column found Nulls and ' ' as shown below Thanks for your help SELECT PROVIDERS_REFERENCE_NO, LENGTH(PROVIDERS_REFERENCE_NO),COUNT(*) FROM DV_RDS.CONTRACT GROUP BY PROVIDERS_REFERENCE_NO PROVIDERS_REFERENCE_NO 2 3 ---------------------- ---- ------ BOWEL CARDDA CARDDIAG...

hi , 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 o...