|
-- [ Picked text/plain from multipart/alternative ] I would be interested in seeing an example of what you are refering to. The entire process that I am attempting is a series of inserts (to save the deleted records to another file) and deletes. "Weatherly, Howard" <hweatherly@dlis.dla.mil> wrote: This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. -- -- [ Picked text/plain from multipart/alternative ] Richard, I believe you can have only one Statement in a QM query, but you can save the SQL to a file type of DDL and use RUNSQLSTM (I was going to post the command but our machine is paying far more attention to something else other than me at the moment!) As an aside, it appears that you could combine the example you gave into one sql statement or is that only part of what you need to do? -- Content-Description: Query manager question From: Richard Reeve Reply-To: midrange-l@midrange.com To: Midrange-l@midrange.com Subject: Query manager question Date: Tue, 15 Jan 2002 10:52:01 -0500 X-Plaintext: Picked text/plain from multipart/alternative -- [ Picked text/plain from multipart/alternative ] -- [ 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. _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email: MIDRANGE-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email: MIDRANGE-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. --------------------------------- 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.