DS_Audit - last deleted job

attu · Post by **attu** » Mon Sep 08, 2008 1:50 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Sep 08, 2008 3:34 pm

What error?

Please help us to help you.

attu · Post by **attu** » Mon Sep 08, 2008 3:41 pm

DataStage/SQL: syntax error Unexpected symbol. Token was LAST.
Scanned command was FROM DS_AUDIT SELECT * WHERE CLASS ="2" AND LAST

ray.wurlod · Post by **ray.wurlod** » Mon Sep 08, 2008 3:54 pm

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%';