Need db2 query to match time stamp field thru JCL

vardhan0007 · Posted: Wed May 28, 2008 8:12 pm

Hi,

I have to write one SQL query to delete some records based on below condition

I have to check the date field in the table which contains time stamp also but i have to match that field to current date if the date(time stamp) in table is lesser than 6 months i have to delete the record from table. This requirement has to achieve thru JCL only.

Thanks in advance.

Harsha.

Craq Giegerich · Posted: Wed May 28, 2008 8:47 pm

You can not do it just using JCL!

If you are sure you want to delete rows that are less than 6 months old then this sql statement will do it
DELETE FROM TABLE WHERE CURRENT TIMESTAMP - DATE_COL < 600000000;

For more than 6 months old change the < to >.

stodolas · Posted: Thu May 29, 2008 7:09 pm

DB2 date functions should let you do this for more readability

WHERE DATE_COL < CURRENT TIMESTAMP - 6 MONTHS