You can also do:
select substr(filespace_name,1,20) from filespaces

and get only 20 chars back.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Neil Schofield
Sent: Wednesday, April 17, 2013 1:09 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] SELECT statements and column widths

Allen

Thanks for the suggestion. The problem I've got is that the reports are the 
sort of ad-hoc SQL scripts that are run by administrators and operators from 
the admin client. While using '-comma' does reduce the column width, it is not 
appropriate in this scenario.

The fact that only the FILESPACE_NAME column is twice as wide as it should be 
makes me wonder if it's a bug?

Regards
Neil




From:
"Allen S. Rout" <asr AT ufl DOT edu>
To:
ADSM: Dist Stor Manager <ADSM-L AT vm.marist DOT edu>
Cc:
Neil Schofield <neil.schofield AT YORKSHIREWATER.CO DOT UK>
Date:
17/04/2013 14:59
Subject:
Re: [ADSM-L] SELECT statements and column widths



On 04/16/2013 04:25 PM, Neil Schofield wrote:
> I'm in the throes of an upgrade from TSM Server 5.5 to 6.3 and have 
> had
a
> bit of a problem re-writing some of our custom SQL scripts. I was
wondering
> if anyone can point out what I'm doing wrong.
>

I don't know from "do wrong"; but the way I approached that was to


dsmadmc -comma -dataonly=yes

and do my formatting in my scripting engine.

- Allen S. Rout






 ----------------------------------------

Spotted a leak?
If you spot a leak please report it immediately. Call us on 0800 57 3553 or go 
to http://www.yorkshirewater.com/leaks

Get a free water saving pack
Don't forget to request your free water and energy saving pack, it could save 
you money on your utility bills and help you conserve water. 
http://www.yorkshirewater.com/savewater

The information in this e-mail is confidential and may also be legally 
privileged. The contents are intended for recipient only and are subject to the 
legal notice available at http://www.keldagroup.com/email.htm
Yorkshire Water Services Limited
Registered Office Western House, Halifax Road, Bradford, BD6 2SZ Registered in 
England and Wales No 2366682