V8.2 doesnot support this? SQL20165N An SQL data change statement within a FROM clause is

#1

INSERT INTO deletetable
select * from old table
(
DELETE FROM existingtable
)
;

#2

On Oct 5, 8:12 am, shenan... (AT) gmail (DOT) com wrote:

Quote:

INSERT INTO deletetable
select * from old table
(
DELETE FROM existingtable
)
;

Not as such, but there is a way around it. Have a look at the slide
titled "Moving duplicate rows" in the "SQL on Fire - Part 2"
presentation available at the following link:

http://www.iiug.org/waiug/present/Fo...Forum2006.html

--Jeff

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

V8.2 doesnot support this? SQL20165N An SQL data change statement within a FROM clause is

comp.databases.ibm-db2 comp.databases.ibm-db2

V8.2 doesnot support this? SQL20165N An SQL data change statement within a FROM clause is - 10-05-2007 , 10:12 AM

Re: V8.2 doesnot support this? SQL20165N An SQL data change statement within a FROM clause is - 10-05-2007 , 01:08 PM