Use the SQL contatenation operator: Select 'del vol ' || volume_name from volumes where stgpool_name='WHATEVERINCAPS'...
Do it right from the dsmadmc command prompt and cut 'n paste right back to execute them. You may have to issue SET SQLDISPLAYMODE WIDE so it all fits on a single line. Actually now that I think about it, if you try to cut n' paste it back in to the dsmadmc command line, you get prompted Yes or No after the first DEL VOL command is issued. Probably better to pipe the output to a file and then use the macro command like Allen used. Bill Boyer >Select * from USERS where CLUE>0 0 rows returned - ?? -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Allen S. Rout Sent: Tuesday, December 05, 2006 5:32 PM To: [email protected] Subject: Re: wildcard del vol? >> On Tue, 5 Dec 2006 16:21:47 -0500, Lawrence Clark <[EMAIL PROTECTED]> said: > Since I'm redoing the volumes on SAN and need to delete the ones auto > generated by TSM, is there a way of wholesale deleteing the existing > volumes without doing an explicit del vol on each? dsmadmc -dataonly -tab " select 'del vol ',volume_name,' wait=yes' where your_criterion_here " > something.macro then TSM:your_server > macro something.macro - Allen S. Rout
