Hi Christian, I am curious as to why a column name longer than 18
characters presents a problem? You can simply put it in quotes, as I
showed in a previous response on this subject.

Best regards,

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.



Christian Demnitz <christian.demnitz AT SINIUS DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03/26/2004 08:19
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

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.