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 <email@example.com> Reply-To: firstname.lastname@example.org To: Midrangeemail@example.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-Lfirstname.lastname@example.org Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.