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
 

 

Edit saved queries in QMF

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

New User


Joined: 12 Sep 2005
Posts: 28

PostPosted: Fri Sep 15, 2006 6:37 am    Post subject: Edit saved queries in QMF
Reply with quote

Hi All,
How to edit the queries stored as database objects in QMF?
(USERID.QUERYNAME).
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Fri Sep 15, 2006 11:04 am    Post subject:
Reply with quote

Hi Ajay,

U casn go to qmf menu & type

LIST QUERIES
it will give u all the query saved by ur tso id

then Query which u want to edit agaist that press F4 it will open a command window.

RUN queryname
it will execute ur query then press F6 now u can edit ur query.

Correction r welcome
Back to top
View user's profile Send private message
Prajesh_v_p

Active User


Joined: 24 May 2006
Posts: 133
Location: India

PostPosted: Fri Sep 15, 2006 5:06 pm    Post subject:
Reply with quote

To add to Guptae,

typing ed at the command line will give you the editor also...

u can use DI USERID.QUERYNAME(once u know the name else you ll have to use list as guptae said)..this will display the query then type ED at the commad line ..this will givw you the editor also...
Back to top
View user's profile Send private message
MFRASHEED

Active User


Joined: 14 Jun 2005
Posts: 186
Location: USA

PostPosted: Fri Sep 15, 2006 7:51 pm    Post subject: Re: Edit saved queries in QMF
Reply with quote

If you know the query name you can also use DISP 'Query-Name'.
Back to top
View user's profile Send private message
ajay_diaz
Warnings : 1

New User


Joined: 12 Sep 2005
Posts: 28

PostPosted: Sun Sep 17, 2006 4:43 am    Post subject:
Reply with quote

Thanks a lot friends!!,......and is there any way by which I can rename the query?
Back to top
View user's profile Send private message
ajay_diaz
Warnings : 1

New User


Joined: 12 Sep 2005
Posts: 28

PostPosted: Tue Oct 03, 2006 8:10 am    Post subject:
Reply with quote

Any pointers on this? icon_sad.gif
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 Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm
No new posts Need help with below queries ashek15 DB2 3 Thu Mar 23, 2017 1:38 am
No new posts Mass comment and edit elixir1986 IBM Tools 3 Thu Mar 02, 2017 10:09 pm
No new posts Use of Edit & FTOV migusd SYNCSORT 3 Wed Jun 08, 2016 1:49 am
No new posts How storage is calculated for AN-Edit... Raghu navaikulam COBOL Programming 2 Wed Mar 09, 2016 3:51 pm


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