Re: Delete in SQL

Try using concatenation of the columns and values

At 03:51 PM 6/29/2005, you wrote:

Do you know how to write a delete statement to delete by a composite
key/

I can do it by one, but 3 doesn't seem to work

This is the last one I tried
                            Specify DELETE Statement



 Type choices, press Enter.



   File . . . . . . . . . . .   ISPFDWJS                 Name, F4 for
list
     Library  . . . . . . . .     waide                  Name, F4 for
list
   Correlation  . . . . . . .                            Name



 Type WHERE conditions, press Enter.

   in (select * from waide/dq32pf2 where ctidwj=ctidwja and
ctckwj=ctckwja
   and sccswj=sscswja)




Bottom
 Type choices, press Enter.



   WITH isolation level . . .   1                1=Current level, 2=NC
(NONE)
                                                 3=UR (CHG), 4=CS, 5=RS
(ALL)
                                                 6=RR

              F10=Copy line   F12=Cancel   F14=Delete line   F
Token WAIDE was not valid. Valid tokens: ) ,.


This is what we normally run----(but I need the sccswj field to make it
unique)

DELETE FROM ISDTAPRD/ISPFDA3 WHERE bfnba3 in  (SELECT * FROM
 waide/dq138SMC)


Bruce Barrett
Systems Consultant
PMI Mortgage Insurance Co.
925-658-6152
bruce.barrett@xxxxxxxxxxxx

This e-mail is confidential and may be privileged. If you are not the
intended recipient, please destroy this message and notify the sender.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.