Question on Delete in Embedded SQL

["Crane, Lori A." <LCrane@xxxxxxxxxxxxxxxx>]

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
+---