Hi,
My source is a flat file and I need to validate the date ,if date is valid then the process should flow else if date is invalid the job should abort.
Pl through some light,
Regards,
Rafidwh
Date Validation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
When validation fails in transformer direct it to a seperate link (You can put a peek stage) and specify in the transformer constraint 'abort after rows' as 1. (Wonder why you want to do this inside a job, not suggested at all). If you are checking for a file with valid date in it you can do this before calling the job itself in a sequence.
Last edited by JoshGeorge on Tue Jun 12, 2007 11:58 pm, edited 1 time in total.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Re: Date Validation
i think you want to check the date format or if the date is valid at execution, i mean to say while you are propogating input data to output.
in tranformer you can check if date is valid, if not you can call an inbuilt routine by Ardent Software, Inc. of sdk UtilityAbortToLog.
in tranformer you can check if date is valid, if not you can call an inbuilt routine by Ardent Software, Inc. of sdk UtilityAbortToLog.