If you wish to take a date and see if it is a valid one, you have some Px conversions that will return an empty or null value when converting invalid inputs; this can be used as a type of validation. The Server variant of DataStage has two very powerful functions called ICONV/OCONV which will do this in a simpler and more efficient manner than Px and it might be worth thinking about doing this type of validation in a server type job.
What sort of validation are you intending on doing?
If we have a date field that has a date value of 01/44/2005, how can I ask datastage to check the date and let me know if it's invalid? I'm looking for something that is similar to COBOL's 'DATE DATA.'
You mentioned px conversions. Can you please elaborate?
If you wish to take a date and see if it is a valid one, you have some Px conversions that will return an empty or null value when converting invalid inputs; this can be used as a type of validation. The Server variant of DataStage has two very powerful functions called ICONV/OCONV which will do this in a simpler and more efficient manner than Px and it might be worth thinking about doing this type of validation in a server type job.
The Px Conversion to use in your case would be StringToDate (page B-12 in the Parallel Job Developer's Guide). I'm away from my Px connection right now, but I think it returns an empty string or null when unsuccessful; you will have to try this on your own.
I still have more trust in the server side calls, as I know they deal with leap-years and other date iniquities quite well; but so should StringToDate.