delete data frm tableA n put tat in tableB

[sanku123]

I need to delete sme data frm a tableA and put that data in other tableB..data in tableA must be deletd..both can be done in same db2 query?.

[r035198x]

No there isn't one query that does it. Why do you need it to be one query? Rather select into a cursor and then use load from cursor for the target table. See here for more details http://www.ibm.com/developerworks/da...m-0901fechner/

[vijay2082]

Hi,

update and delete are 2 transactions and can't be provided in same query. This is against RDBMS principles and is there to provide the data integrity.

Cheers, Vijay