RE: Query manager question

["Weatherly, Howard" <hweatherly@xxxxxxxxxxxx>]

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 <richreeve@yahoo.com>
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.