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.
sachin1 - that would work only for a server job or if a BASIC transform stage were used in a PX job. The method shown by JoshGeorge above is a common way to abort a job with a given data condition by splitting the stream and setting a trigger to abort the job if any data goes down the error stream.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>