Re: CL

Not sure I totally understand you questions, but you appear to be looking for yesterday's date and date arithmetic is not straight forward in CL.

Take a look at this page:
https://www.rpgpgm.com/2017/03/determine-end-of-month-using-cl.htmlnd You could probably tweak the CL/SQL solution for your needs.

Then you would probably need the job scheduler to submit the job automatically. Have a look at the WRKJOBSCDE and ADDJOBSCDE commands.



On 1/5/2021 9:51 AM, techie21 IT wrote:

Hi,

How can I modify a CL program in such a way that it should pickup system's
date
to run everyday and process previous day's data when it runs. for example
if it runs at 00:15 am then it should run for all the data till previous
day which is present in it.
also there is one more condition like here we need to keep CTCD ,GMAB
values static and only BRNO field will have different values (which it will
pickup after reading some file).
below is the code scratchpad link for the same:-

https://code.midrange.com/39e008f6c5.html