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:[EMAIL PROTECTED] Sent: Friday, March 26, 2004 10:03 AM To: [EMAIL PROTECTED] 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.
