View previous topic :: View next topic
|
Author |
Message |
dmithunibm
New User
Joined: 23 May 2007 Posts: 18 Location: Bangalore
|
|
|
|
Hi All,
I had created a QMF query named 'IN0584.PIPS01N',which has the below content:
SELECT DISTINCT A.BANK_XXXX
,A.NAME
,A.SD_PDB
,A.CPY_CODE
,MONTH(A.STOP_PAY)
,YEAR(A.STOP_PAY)
FROM IN0584.XXXXXXXX A
,IN0584.XXXXXXXX B
WHERE A.BANK_NMBR = B.BANK_NMBR
AND A.BANK_NMBR > '0000000000XX'
AND A.SD_PDB ^= B.SD_PDB
AND MONTH(A.STOP_PAY)=MONTH(CURRENT TIMESTAMP)
AND MONTH(A.STOP_PAY)=MONTH(B.STOP_PAY)
AND YEAR(A.STOP_PAY)=YEAR(CURRENT TIMESTAMP)
AND YEAR(A.STOP_PAY)=YEAR(B.STOP_PAY)
ORDER BY 1
But can anyone tell me how do I delete the WHOLE QMF Query from the database ?Is there any command which I can issue from QMF COMMAND Line? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
sorry, I am as lazy as you are and don't want to look up anything in the documentation or even bother invoking qmf and going thru the f1 help. |
|
Back to top |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005 Posts: 306
|
|
|
|
You can user erase command
Erase queryname |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
QMF provides a nice list of all QMF commands: F1? |
|
Back to top |
|
|
|