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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.