PLease help me how to check a job last deleted by date in Audit Table
SELECT * FROM DS_AUDIT WHERE CLASS ='2' AND LAST DELETED DATE = 2008-09-08
getting error.
Thanks
DS_Audit - last deleted job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Column names in DS_AUDIT don't have spaces in them. The error message showed that DataStage/SQL was happy with everything up to "LAST". But not with "LAST DELETED DATE". The correct name for the column, from memory, is PREVDTD (but you should check this with LIST.DICT DS_AUDIT). Also, since these are string timestamps, you may not find it with just a date unless you use LIKE and a wildcard for the time component.
Code: Select all
SELECT * FROM DS_AUDIT WHERE CLASS ='2' AND PREVDTD LIKE '2008-09-08%';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.