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:[EMAIL PROTECTED] Behalf Of Andrew Raibeck Sent: 26 March 2004 15:49 To: [EMAIL PROTECTED] 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/[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. "Smith, Rachel" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 03/26/2004 08:29 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Behalf Of Andrew Raibeck Sent: 26 March 2004 15:27 To: [EMAIL PROTECTED] 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/[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. "Smith, Rachel" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 03/26/2004 08:22 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Re: Antwort: define script problem that worked, thanks for that:> -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Christian Demnitz Sent: 26 March 2004 15:19 To: [EMAIL PROTECTED] 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:[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.
