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/[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:19 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] 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:[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.
