Quick and dirty:

You can use an SQL select statement to build all the UPDATE statements you
need.

Change the SQL select statement below so that LIBRARYNAME is the name of
your library.  It should be in upper case.

Then run the query and redirect the output into a file.

Edit the file to delete the header lines.

Then run the file as a macro by entering the command:  macro filename


 select 'udate libv libraryname', volume_name, ' status=scratch'  from
libvolumes where status='Scratch' and library_name='LIBRARYNAME' >
c:\pathname\filename