Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

can we run two queries in same qmf window

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
nandeshwar

New User


Joined: 11 Oct 2010
Posts: 44
Location: Delhi

PostPosted: Tue Jan 18, 2011 7:17 pm    Post subject: can we run two queries in same qmf window
Reply with quote

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
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue Jan 18, 2011 8:15 pm    Post subject:
Reply with quote

which qmf? TSO ? for windows V8 ? for workstation V9 ?

Where are you going to view the result ?
Back to top
View user's profile Send private message
Dsingh29

Active User


Joined: 16 Dec 2008
Posts: 132
Location: IBM

PostPosted: Wed Jan 19, 2011 11:16 am    Post subject:
Reply with quote

simply try and test !!!

btw i dont think you can run two quries simultenously in QMF.

when please let us know the results icon_wink.gif
Back to top
View user's profile Send private message
nandeshwar

New User


Joined: 11 Oct 2010
Posts: 44
Location: Delhi

PostPosted: Wed Jan 19, 2011 12:12 pm    Post subject:
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Wed Jan 19, 2011 1:24 pm    Post subject:
Reply with quote

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
View user's profile Send private message
muralitharant

New User


Joined: 15 Nov 2006
Posts: 1
Location: Mysore

PostPosted: Tue Feb 01, 2011 2:59 pm    Post subject:
Reply with quote

You can use DB2 Platinum and can run any number of queries simultaneously and see the results one after the other.
Back to top
View user's profile Send private message
nandeshwar

New User


Joined: 11 Oct 2010
Posts: 44
Location: Delhi

PostPosted: Fri May 06, 2011 4:09 pm    Post subject:
Reply with quote

@muralitharant can you please explain how?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm
No new posts Re-write queries to minimize the effe... Anil Khanna DB2 6 Mon Aug 04, 2014 1:49 pm
No new posts Running multiple queries in a PS file... nikhil_bansal04 JCL & VSAM 12 Wed Dec 18, 2013 12:06 pm
No new posts IBM Debug Tool - Need help in window ... satish.ms10 IBM Tools 4 Tue Jul 02, 2013 7:07 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us