Need a Delete query

johnjohn055 · New User Joined: 15 Aug 2008 Posts: 5 Location: PUNE

Hi,

My requirement is as follows. I need a query to Delete rows from Table A based on BILL_DATE is <= CURRENT DATE - 7 YERAS. BILL_DATE column is defined as CHAR (6) in TABLE A. So if i'll write Delete from Table A WHERE BILL_DATE is <= CURRENT DATE - 7 YERAS, getting sqlcode -180 because column is defined as char. As per my knowledge SUBSTR function won't support while Deleting from Table.

If anyone having any ideas please let me know.

Thanks
John

Craq Giegerich · Posted: Mon Feb 02, 2009 9:03 pm

I wish designers would learn about DB2 before they start designing. What is the format of the data in BILL_DATE.

Ajay Baghel · Posted: Mon Feb 02, 2009 10:04 pm

Hi John,

If the BILL_DATE is character string like below:
'2002-10-20'

You can issue the below query:
Delete from Table A WHERE
DATE(BILL_DATE) is <= ( CURRENT DATE - 7 YEARS )

Thanks,
Ajay

Bharath Bhat · Posted: Mon Feb 02, 2009 10:20 pm