--
[ Picked text/plain from multipart/alternative ]

All,

     I have created a source member that has multiple inserts and deletes in 
it.  I am basically saving the record that I will subsequently delete.  Here is 
a snipet of the memeber;

INSERT INTO QGPL/VSCP015SV SELECT * FROM vscp015 WHERE smname =
'VTMM00' AND secopt = '03';
delete from vscp015 where smname = 'VTMM00' AND secopt = '03';
--
INSERT INTO QGPL/VSCP015SV SELECT * FROM vscp015 WHERE smname =
'VTMM00' AND secopt = '14';
delete from vscp015 where smname = 'VTMM00' AND secopt = '14';
--

My question/problem is this - I need to convert to query manager but don't see 
how I can accomplish.  Any thoughts?





---------------------------------
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.