Mass Delete of Queries

[Former Member]

Hi all,

We could use RSZDELETE Tcode to delete a single Query. We have 700+ Queries and we have to delete them as part of clean-up. Is there any way of mass deletion of Queries so that we could delete them in single shot?

Thanks in advance.

[Former Member]

Hi,

Can you please help me how to use the batch input to delete a mass of queries?

Do we need a bathc input program that allows to delete the file that contains all queries?

thx,

Marta.

[venkat_kodi]

Hi Marta,

Sorry. I haven't worked on it after that since this task was postponed by the client.

Thanks.

[ivo_robbrecht3]

The queryid in RSZDELETE will take a wildcard.

Ex. Just enter Z* to delete all queries starting with the letter Z

Ivo

[Former Member]

Do a batch input to transaction rszdelete.

[Former Member]

Hi Oscar,

Thanks for your quick response.

Could you please explain in detail about this batch input?

Thanks..

[Former Member]

Do you know about batch inputs?

If you can download query names to a file, you can read that file and do a call transaction to rszdelete for each one. Then automatically you will delete the 700 queries. I never did a mass delete, but it can be a good idea