Hello, how can I perform calculations based off of the current system time with CARLa?

For example if I have the below:

newlist type=smf nopage dd=ckrcmd
  select exists(racfcmd) ( TIME=0700:0800)
  sortlist racfcmd(hor,wrap,0)​

I'd like to instead of hard-coding the time do something similar to CURRENT_TIME-0200:CURRENT_TIME (2 hour window) but cannot figure out the CARLa to do so

Also adding in an example with DATE offsets would be helpful

Thank you!

- Adam Klinger

------------------------------
Adam Klinger
------------------------------

Hi Adam
With dates you can use TODAY as a date value, for example, this finds passwords expiring in the next 7 days.
SELECT PASSWORD_EXPIRE_DATE>TODAY AND PASSWORD_EXPIRE_DATE<=TODAY+7
There is no such keyword for TIME.
Also, calculations (additions, subtractions) are impossible, except for the example given.

Look at  SCKRCARL for samples how to build reports with date or time ranges:
CKALFSTA - statistics per hour
CKALFSTB - statistics per shift
CKALFSTC - statistics per weekday

------------------------------
Rob van Hoboken
------------------------------

Original Message:
Sent: Fri December 20, 2019 10:03 AM
From: Adam Klinger
Subject: zSecure CARLa -- Timestamp Offsets

Hello, how can I perform calculations based off of the current system time with CARLa?

For example if I have the below:

newlist type=smf nopage dd=ckrcmd  select exists(racfcmd) ( TIME=0700:0800)  sortlist racfcmd(hor,wrap,0)​

I'd like to instead of hard-coding the time do something similar to CURRENT_TIME-0200:CURRENT_TIME (2 hour window) but cannot figure out the CARLa to do so

Also adding in an example with DATE offsets would be helpful

Thank you!

- Adam Klinger

------------------------------
Adam Klinger
------------------------------