ADSM-L

Another select question

2015-10-04 17:33:44
Subject: Another select question
From: Dana Mitchell;
To: ADSM-L AT VM.MARIST DOT EDU
Hello,

I am working on coding SELECT commands to display errors from clients.  I
would like to get just the errors from the last 24 hours but I can't get it
to work.  This is with TSM 3.7.0 under OS/390.  I have tried various
combinations such as:

SELECT DATE_TIME, MESSAGE, NODENAME, SEVERITY -
FROM ACTLOG -
WHERE NODENAME IS NOT NULL AND -
SEVERITY = 'E' AND -
(DATE_TIME = (CURRENT_TIMESTAMP)DATE OR -
 DATE_TIME = (CURRENT_TIMESTAMP)DATE - 1)



and I can't find a way to get it to work without hard coding the date and
time.  Does anyone have any suggestions or examples of this type of code?

Thanks in advance
Dana
<Prev in Thread] Current Thread [Next in Thread>