This stuff will make you crazy.  Give up your pain!!!

Use notepad (or vi, or whatever) to create your script in a flat file.
Type the SELECT just as you would from the command line, no worry about
extra quotes.

Then

DEFINE SCRIPT VAULTING desc="Create Vault Lists"  file=\pathname\filename




-----Original Message-----
From: Smith, Rachel [mailto:Rachel.Smith AT IRL.XEROX DOT COM]
Sent: Friday, March 26, 2004 10:03 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: 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.