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:christian.demnitz AT sinius DOT com





"Smith, Rachel" <Rachel.Smith AT IRL.XEROX DOT COM>
Gesendet von: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
26.03.2004 16:02
Bitte antworten an
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


An
ADSM-L AT VM.MARIST DOT EDU
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.