If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Deleting QMF procs

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-28-09, 21:14
tataforums tataforums is offline
Registered User
 
Join Date: Feb 2009
Posts: 9
Question how to delete QMF procs

Hi,

We only learned how to created a QMF query / proc.

Now we have a need to delete few QMF procs from the system.

Is there any mechanism to delete QMF procs / Queries?

Please help.

Last edited by tataforums; 05-28-09 at 21:21.
Reply With Quote
  #2 (permalink)  
Old 05-28-09, 22:22
Stealth_DBA Stealth_DBA is offline
Registered User
 
Join Date: May 2009
Posts: 472
tataforums, I believe the keyword is ERASE. For example:

ERASE PROC proc-name
Reply With Quote
  #3 (permalink)  
Old 05-29-09, 00:49
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
if these terms related to Zos ?
__________________
Rahul Singh
Certified DB2 9 DBA / Application Developer
Reply With Quote
  #4 (permalink)  
Old 05-29-09, 10:20
dav1mo dav1mo is offline
Registered User
 
Join Date: Dec 2007
Location: Richmond, VA
Posts: 782
Rahul,
yes, though there is a QMF product for windows.

Tata,
You can list procs or list queries and erase them as mentioned, erase them by name, or you can set up process to delete from the QMF tables, which I would advise against.
Dave
Reply With Quote
  #5 (permalink)  
Old 05-31-09, 23:04
tataforums tataforums is offline
Registered User
 
Join Date: Feb 2009
Posts: 9
Thank you very much

Its working with ERASE.
Reply With Quote
  #6 (permalink)  
Old 02-01-10, 08:29
JoannieA JoannieA is offline
Registered User
 
Join Date: Jan 2010
Posts: 1
Quote:
Originally Posted by Stealth_DBA View Post
tataforums, I believe the keyword is ERASE. For example:

ERASE PROC proc-name
Thank you very much for this info. I have been able to get rid of some ancient queries which could have been run in error. I used ERASE QUERY.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On