Routine to data validate

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
RAI ROUSES
Participant
Posts: 176
Joined: Wed Nov 15, 2006 5:48 am

Routine to data validate

Post by RAI ROUSES »

hi,
i have a numerical field that have a date (in format YYYYMMDD), i would like to validate if it corresponds to a correct date or not, there is any function/routine that allows to do this validation?
regards
rai
Raghavendra
Participant
Posts: 147
Joined: Sat Apr 30, 2005 1:23 am
Location: Bangalore,India

Post by Raghavendra »

I believe you can check with Iconv function.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yes, you can - a combination of IConv and the Status function.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply