How can I dynamically pass the result of DB2 TRUNC_TIMESTAMP of any kind in my JCL steps?
I am looking to create a JCL stream that will do the following:
Step 1: Run a instream DB2 Param1 = Select TRUNC_TIMESTAMP(CURRENT TIMESTAMP,'MONTH'**) from SYSIBM.SYSDUMMY1;
Step 2: Param2 = Select TRUNC_TIMESTAMP(CURRENT TIMESTAMP + 1 month,'MONTH')- 1 MICROSECOND)** from SYSIBM.SYSDUMMY1;
Step 3: Select count(*) from HLVQUAL.TABLE_NAME where CREATE_TS between Param1 AND Param2
I will highly appreciate any examples, how-tos and other helpful comments to resove my issue.