RE: Query manager question

> From: Richard Reeve [mailto:richreeve@yahoo.com]
> I would be interested in seeing an example of what you are referring to.

Create a source file, I called my QSQLSRC. Add a member and edit it with
SEU. In the member type:

Insert into table1 (fld1, fld2) values('A', 'B');
Delete from table1 where fld1='A';

Save source member. Prompt RUNSQLSTM and give it the file and member. Also,
since the example doesn't have a commit at the end change commit() to *NONE
and hit enter.

-Walden

PS. Note the semicolon at the end of each sql statement. A SQL statement can
span multiple lines in the source file so the ; tells the command where the
SQL statement ends.

------------
Walden H Leverich III
President
Tech Software
(516)627-3800 x11
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com



-----Original Message-----
From: Richard Reeve [mailto:richreeve@yahoo.com]
Sent: Tuesday, January 15, 2002 12:34
To: midrange-l@midrange.com
Subject: RE: Query manager question


--
[ 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.
_______________________________________________
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.