how to implement the below rule in Datastage?
i have a column "TransDate" the datatype is char and format is yyyymmdd
yyyy should be start with "20"
mm shd be value 01 through 12.
how to validate date function in datastage?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 48
- Joined: Fri Feb 29, 2008 1:09 am
- Location: Bangalore
Re: how to validate date function in datastage?
what is your source?balaya.ds wrote:how to implement the below rule in Datastage?
i have a column "TransDate" the datatype is char and format is yyyymmdd
yyyy should be start with "20"
mm shd be value 01 through 12.
If it is a database use database function to convert into date and check if the date is greater than 31-dec-1999
If sequential file Swathi's reply will help.