ANR2002E Missing closing quote character

[chiharu88]

Hi guys,
Im try to create a script that will list all the scratch tapes name but im getting an missing quote error.

define script scratch "select volume_name AS "Scratch Volumes" from libvolumes where status='Scratch' and volume_name like '%L6'"


can you guys help?

 

[marclant]

It doesn't like the quotes around "Scratch Volume", the first quote before the S closes the original quote. Try using removing the space so that you don't need the quotes instead:

define script scratch "select volume_name AS Scratch_Volumes from libvolumes where status='Scratch' and volume_name like '%L6'"