Page 1 of 1

HOW-MANY DAYS in Cobol

PostPosted: Thu Oct 24, 2013 5:10 pm
by surime72
Hi,
Variable HOW-MANY DAYS is defined our programs,But not sure what will do it can any one suggest on this..?

    WHERE GCPE47_INSERT_S > (CURRENT TIMESTAMP
                             - :HOW-MANY DAYS)
      AND A.GCPA15_GLOBL_FSA_R = B.GCPA15_GLOBL_FSA_R
      AND B.GCPA16_LAUNCH_Y > "2008-12-31"

Re: HOW-MANY DAYS in Cobol

PostPosted: Thu Oct 24, 2013 5:48 pm
by Akatsukami
The variable is HOW-MANY; DAYS is a SQL keyword. As to what is does,read the fine manual.

Re: HOW-MANY DAYS in Cobol

PostPosted: Thu Oct 24, 2013 5:55 pm
by surime72
Thanks for reply,Can you please explain how it will work,if possible with example

Re: HOW-MANY DAYS in Cobol

PostPosted: Thu Oct 24, 2013 7:35 pm
by dick scherrer
Hello,

Suggest you look at the code and learn the way "HOW-MANY" is calculated.
Then learn the content of GCPE47_INSERT_S and how this was created.
Then determine why the difference (in days) is needed for this bit of code.

Re: HOW-MANY DAYS in Cobol

PostPosted: Fri Oct 25, 2013 4:38 pm
by surime72
thanks I got it...!

Re: HOW-MANY DAYS in Cobol

PostPosted: Mon Oct 28, 2013 12:40 am
by dick scherrer
Cool - thanks for letting us know :)

d