Send email if date variable of a file matches current date

ARUN.A.NAIR · Posted: Thu Mar 08, 2007 5:26 pm

Hi,

I WANT TO WRITE A JCL (CANNOT AFFORD TO WRITE A COBOL PROGRAM FOR THIS) THROUGH WHICH I HAVE TO COMPARE A FILE (WHICH HAS AN INDICATOR( 1 BYTE LENGTH) AND DATE AS IT'S FIELDS) WITH THE CURRENT DATE. IF THE DATE IN THE FILE MATCHES WITH THE CURRENT DATE THEN I HAVE TO SEND AN EMAIL. CAN ANYONE HELP ME REGARDING THIS PLEASE :-)

THANKS AND REGARDS,
ARUN.A.NAIR

Warning: Caps ON

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

Hi,

You can easily compare dates using sort.

If you want to select records in which a 10-character date in the form C?yyyy/mm/dd? starting in position 42 equals today?s date, write: INCLUDE COND=(42,10,CH,EQ,DATE1(/)).

You can use the above condition to make a temporary sort out,
and then using that file for ur Email step.

Thanks,
-Kapil.

ARUN.A.NAIR · Posted: Fri Mar 09, 2007 6:04 pm

Hi,

Thanks for the speedy reply Kapil.

Can you please advice me how I can reformat the date field to check a field which is in 'yyyy-mm-dd' format ???

Thanks and regards,
Arun.A.Nair

ARUN.A.NAIR · Posted: Fri Mar 09, 2007 6:11 pm

Hi,

I just tried to run the program with the condition which was adviced in the above reply. But it seems like "INCLUDE COND=(42,10,CH,EQ,DATE1(/)). " is accepting any date in that format and not the current date. Can anyone advice me regarding getting the current date????

superk · Posted: Fri Mar 09, 2007 6:48 pm

The code that was given earlier works fine.

What is the RECFM and LRECL of your input file? What do you want for the RECFM and LRECL of the output file?

What position in the file does the date start in? What format is it in (you mentioned it should be yyyy-mm-dd)?

ARUN.A.NAIR · Posted: Fri Mar 09, 2007 7:00 pm

Hi,

Thanks for the reply. I am sorry as I didn't clearly mention all the parm's .
The input and output RECFM is FBA and the LRECL is 80 for both. The date starts in 2nd position.

Hence I used the following code :-
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(2,8,CH,EQ,DATE1(/))
//*

But the output file gets populated even when I mention any other dates other than today's date of the month i.e, when I enter date as 2007/03/31 then also the output file gets populated. But when I give date with different month or year the output file is not populated. I also would like to know how to format the date field so that i can compare a date in 'yyyy-mm-dd' format.

Thanks and regards,
Arun.A.Nair

superk · Posted: Fri Mar 09, 2007 7:17 pm

This code:

William Thompson · Posted: Tue Mar 13, 2007 5:51 pm