Correct, but the embedded quotes also makes this a bit tricky. Note that
the string comparison in the WHERE clause requires single quotes around
MOUNTABLE. So how about this:
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"
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
Christian Demnitz <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
03/26/2004 08:12
Please respond to
"ADSM: Dist Stor Manager"
To
[EMAIL PROTECTED]
cc
Subject
Antwort: define script problem
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.
