Ah, OK. Now that makes sense. Thanks for confirming that I'm not not nuts
(at least not because of this!)

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.



"Smith, Rachel" <Rachel.Smith AT IRL.XEROX DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03/26/2004 08:59
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: Antwort: define script problem






I ran it with single quotes around MOUNTABLE:
DEFINE SCRIPT VAULTING "select volume_name as Vol_to_go_offsite, voltype
as
Volume_Type from drmedia where state='MOUNTABLE' order by volume_name"
desc="Create vaulting lists"

ANR1462I RUN: Command script VAULTING completed successfully.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Andrew Raibeck
Sent: 26 March 2004 15:49
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Antwort: define script problem


While I agree that it is difficult to argue with success, I don't see how
the script could possibly run as written below. You had to have changed
something else. Here are the results if you run the script as written (I
simply copy & pasted it into the admin command line):



tsm: SS2_ADSM_GROUP_SERVER>DEFINE SCRIPT VAULTING "select volume_name as
Vol_to_go_offsite, voltype as Volume_Type from
drmedia where state="MOUNTABLE " order by volume_name" desc="Create vault
lists"
ANR2023E DEFINE SCRIPT: Extraneous parameter - MOUNTABLE.
ANS8001I Return code 3.

tsm: SS2_ADSM_GROUP_SERVER>



SQL doesn't like double quotes around MOUNTABLE; string comparisons must
be done with single quotes.

Would you mind showing me the output from QUERY SCRIPT VAULTING? And if it
is defined with double quotes around MOUNTABLE, can I see the output from
RUN VAULTING?

Not trying to be argumentative, but simply trying to understand how it can
work as written.

Thanks,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.



"Smith, Rachel" <Rachel.Smith AT IRL.XEROX DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03/26/2004 08:29
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: Antwort: define script problem






I changed the name for vol_to_go... and ran successfully with no errors.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Andrew Raibeck
Sent: 26 March 2004 15:27
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Antwort: define script problem


The script may get defined, but it probably won't run. See my other post
on this subject.

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.



"Smith, Rachel" <Rachel.Smith AT IRL.XEROX DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03/26/2004 08:22
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: Antwort: define script problem






that worked, thanks for that:>

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Christian Demnitz
Sent: 26 March 2004 15:19
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Antwort: define script problem


sorry my first answer was wrong!!!

please try:

DEFINE SCRIPT VAULTING "select volume_name as Vol_to_go_offsite, voltype
as Volume_Type from drmedia where state="MOUNTABLE " order by volume_name"
desc="Create vault lists"

the only restriction is: the name for vol_to_go... should not longer than
18 characters!
it will work fine

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.