I had created a QMF query named 'IN0584.PIPS01N',which has the below content:
SELECT DISTINCT A.BANK_XXXX
FROM IN0584.XXXXXXXX A
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 YEAR(A.STOP_PAY)=YEAR(CURRENT TIMESTAMP)
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?