Validate the Date

girishb2 · New User Joined: 30 Sep 2006 Posts: 13

Hello,
I'm automating one job. Before the job load/process the data I have to validate it. My input PS file should have current-1 month data. The file is with 80 LRECL and at 71 position the date is there.. for e.g 08/20/2017
I have to verify it and ensure that the data is for previous month. Once I'm done with it I can load that data.

How can I do it with ICETOOL?

sergeyken · Posted: Tue Sep 19, 2017 1:20 am Post subject:

Did you try to do something yourself (before asking others to do your job)?

girishb2 · New User Joined: 30 Sep 2006 Posts: 13

yes sergeyken, I tried SORT with "DATE1" but its not working and also I dont want to reformat the data, just to validate it. Could you please help in correcting the syntax and how can I just validate it.

SORT FIELDS=COPY
INCLUDE COND=(71,10,Y4W,LT,Y'DATE1(/)'-m)

magesh23586 · Posted: Tue Sep 19, 2017 6:34 am Post subject: Reply to: Validate the Date

What do you need to do when validation fails ?

Abend the job ?

Below is an example to compare the date.

girishb2 · New User Joined: 30 Sep 2006 Posts: 13

Thanks Magesh. I will test this with my file.

No, I dont want to abend the job. I just want to set Maxcc 2 and then have IF THEN condition to avoid running the subsequent steps if the validation fails.

magesh23586 · Posted: Tue Sep 19, 2017 7:14 am Post subject:

I dont think maxcc 2 is possible in DFSORT.

May be you can set RC4 using DFSORT.

girishb2 · New User Joined: 30 Sep 2006 Posts: 13

I believe this will just fetch the date. I want to validate/ensure that the dataset has previous month data and once I do, I can process it.

Thats why I was trying to DATE1. I need to know the syntax for it. I will search it in DFSORT manual and If I dont find I will ask the question

Rohit Umarjikar · Posted: Tue Sep 19, 2017 8:53 pm Post subject:

Try this method and change to your positions in the data set accordingly.
And then code IF conditions to subsequent steps accordingly for rest of your JCL.

girishb2 · New User Joined: 30 Sep 2006 Posts: 13

My file has input data as yyyymmdd - e.g. 20170801 and I found easy way to validate. It worked.

SORT FIELDS=COPY
INCLUDE COND=(71,08,CH,LT,DATE2)

Rohit Umarjikar · Posted: Wed Sep 20, 2017 7:57 pm Post subject: