How to run below SQL without using cursor

Posted in 2018

CHUAN LU — Thu, 25 Jan 2018 07:20:53 — source: IIUG Forums & Mailing Lists

delete from (select first 5 * from t1) as tmp1; thanks.

↪ replying to CHUAN LU

Andreas Legner1 — Thu, 25 Jan 2018 10:16:56 — source: IIUG Forums & Mailing Lists

delete from (select first 5 * from customer) as cust_tmp; 201: A syntax error has occurred. Error in line 1Near character position 13 What exactly are you trying to achieve here? From: "CHUAN LU" <luchuan@cn.ibm.com> To: ids@iiug.org Date: 01/25/2018 08:21 AM Subject: How to run below SQL without using cursor [40567] Sent by: ids-bounces@iiug.org delete from (select first 5 * from t1) as tmp1; thanks. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Andreas Legner1

CHUAN LU — Fri, 26 Jan 2018 08:37:24 — source: IIUG Forums & Mailing Lists

It's DB2 syntax, it can used for delete record repeatly, and avoid long transaction.

↪ replying to CHUAN LU

Andreas Legner1 — Fri, 26 Jan 2018 10:05:52 — source: IIUG Forums & Mailing Lists

The way I'd read this syntax is: delete (everything) from a derived table just being created and populated by this very statement - and only existing for the duration of this statement. With the 'everything' in place: what's the point in doing this? With a limited delete instead: why don't you limit the select in the first place? Anyway, nothing of your 'tmp1' table would remain after the statement finished. From: "CHUAN LU" <luchuan@cn.ibm.com> To: ids@iiug.org Date: 01/26/2018 09:38 AM Subject: Re: How to run below SQL without using cursor [40579] Sent by: ids-bounces@iiug.org It's DB2 syntax, it can used for delete record repeatly, and avoid long transaction. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.