Hi, i think you' forgot the "as" between volume_name and "volumes to go Offsite"
DEFINE SCRIPT VAULTING "select volume_name as "Volumes to go offsite", voltype as "Volume Type" from drmedia where state="MOUNTABLE " order by volume_name" desc="Create vault lists" Christian Demnitz mailto:[EMAIL PROTECTED] "Smith, Rachel" <[EMAIL PROTECTED]> Gesendet von: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 26.03.2004 16:02 Bitte antworten an "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> An [EMAIL PROTECTED] Kopie Thema define script problem Hi, I am trying to create a script that will produce a list of media to send offsite. I defined a script: DEFINE SCRIPT VAULTING "select volume_name "Volumes to go offsite", voltype as "Volume Type" from drmedia where state="MOUNTABLE " order by volume_name" desc="Create vault lists" And it fails with: ANR2023E DEFINE SCRIPT: Extraneous parameter I know it is something to do with the double quotes, but I also tried single quotes but it failed with the same error. Could someone tell me what I'm missing. Thanks again.
