|
View previous topic :: View next topic
|
| Author |
Message |
nandeshwar
New User
.jpg)
Joined: 11 Oct 2010
Posts: 45
Location: Delhi
|
|
|
|
| is there any way to run two separate query in the same qmf window... as i want both the queries to run back to back. |
|
| Back to top |
|
 |
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
which qmf? TSO ? for windows V8 ? for workstation V9 ?
Where are you going to view the result ? |
|
| Back to top |
|
|
Dsingh29
Active User
Joined: 16 Dec 2008
Posts: 132
Location: IBM
|
|
|
|
simply try and test !!!
btw i dont think you can run two quries simultenously in QMF.
when please let us know the results  |
|
| Back to top |
|
|
nandeshwar
New User
Joined: 11 Oct 2010
Posts: 45
Location: Delhi
|
|
|
|
| GuyC wrote: |
which qmf? TSO ? for windows V8 ? for workstation V9 ?
Where are you going to view the result ? |
Sorry for ur inconvenience.
I am using it in TSO.
I want to view the result there only, i mean the QMF window. So can we concatenate two separate qmf queries to run back to back in same QMF(TSO) window?
Say first queriy Locks the table for the particular session and then we process on it.
let me know whether i am clear in my question? |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
No, you can not write two sql statement in 1 query and run it.
What you can do is write a qmf procedure which runs 2 or more qmf-queries in succession. and then run that procedure.
so you need
- a query with the first sql-statement
- a query with the second sql-statment
- a procedure with two RUN statements.
Check the QMF manual about PROCs or try to figure it out with PF1 it is not so difficult. |
|
| Back to top |
|
|
muralitharant
New User
.jpg)
Joined: 15 Nov 2006
Posts: 1
Location: Mysore
|
|
|
|
| You can use DB2 Platinum and can run any number of queries simultaneously and see the results one after the other. |
|
| Back to top |
|
|
nandeshwar
New User
Joined: 11 Oct 2010
Posts: 45
Location: Delhi
|
|
|
|
| @muralitharant can you please explain how? |
|
| Back to top |
|
|
|
|
