Re: Question on Delete in Embedded SQL

[booth@xxxxxxxxxxxx]

I have no answer, but only a question.  Why would the statement include an 
"order by"?  doesn't this just compound the complexity and performance of 
the SQL?

(I am not critiquing, i am just really curious.)

_______________________
Booth Martin
Booth@MartinVT.com
http://www.MartinVT.com
_______________________




"Crane, Lori A." <LCrane@DoanePetCare.com>
Sent by: owner-rpg400-l@midrange.com
04/03/2001 09:41 AM
Please respond to RPG400-L

 
        To:     "'RPG400-L@midrange.com'" <RPG400-L@midrange.com>
        cc: 
        Subject:        Question on Delete in Embedded SQL
Hello,

I have a question on delete in an embedded SQL.  Could anyone help me out.
Does anyone have an example of a working delete using SQL?  I am trying to
delete records out of two files with the same key.  My attempt is below.

Thanks in advance for any help
Lori Crane


7.00 **-*-*-*-*

8.00 **

4.00 **-*-*-*-*

5.00 c/exec SQL

6.00 c+ DECLARE C1 CURSOR FOR

7.00 c+  DELETE DOBPTP10 DOBPTP20

9.00 c+  WHERE order# = :DelORDER and

9.01 c+       dobptp10.ptagno = dobptp20.ptagno

2.00 c+  ORDER BY dobptp10.order# ,dobptp10.PTAGNO

3.00 c/end-exec

4.00 **-*-*-*-*

5.00

6.00 **-*-*-*-*

7.00 c/exec SQL

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: 
david@midrange.com
+---




+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---