|
-- [ 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 mailing list archive is Copyright 1997-2024 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.