Hello,
Is is possible to create a CL that automatically change a query date every day? I'm planning to have the Call program run on schedule by putting it in the WRKJOBSCDE.
So far all i managed to obtain is the select command of the query by using the RTVQMQRY command and here is what i got:
the only variable that i wish to change is the 20210129. i usually manually changed it from the WRKQRY select record but is it possible to change it daily using CL ? What other information do i need to collect ?
Thank you
Is is possible to create a CL that automatically change a query date every day? I'm planning to have the Call program run on schedule by putting it in the WRKJOBSCDE.
So far all i managed to obtain is the select command of the query by using the RTVQMQRY command and here is what i got:
Code:
000100212901H QM4 05 Q 01 E V W E R 01 03 21/29/01 13:50 000200212901V 1001 050 QUERY RESULT FOR TODAY 000300212901V 5001 004 *HEX 000400212901SELECT 000500212901 ALL T01.TBRN, T01.TCDNO, CXNAMK AS CIF, T01.TPLAN#, T01.TNAM, 000600212901 (T01.TBITRT), T01.TISSD, T01.TCBL 000700212901 FROM VISIONA/TBAL T01 INNER JOIN 000800212901 VISIONA/CXREF T02 000900212901 ON TCDNO = CXNOAC 001000212901 WHERE TPLAN# IN (231, 241, 251, 261) 001100212901 AND TISSD = 20210129 001200212901 ORDER BY 006 ASC, 001 ASC
Thank you
Comment