Neil

Had something similar, again with the filespace_name column

To resolve, i do this:

select char(filespace_name,20), etc

On 16 April 2013 21:25, Neil Schofield
<neil.schofi...@yorkshirewater.co.uk>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 understand that to get the select statements to return a table format
> instead of a list format I need to use the cast function to restrict the
> column width - this article explains the theory:
> http://www-01.ibm.com/support/docview.wss?uid=swg21502715
>
> The problem I have is that it doesn't work on any table which has
> FILESPACE_NAME as a column - eg occupancy, filespaces, volumeusage, etc.
> Whenever I do a SELECT CAST(FILESPACE_NAME AS CHAR(n)), I get the
> filespace_name truncated to n characters (good) but in a column that is 2 x
> n characters wide (bad). Other fields in the same tables with the same data
> type - ie VARCHAR - do not suffer the same effect and it's got me stumped.
>
> In the example below, does anyone have any idea how I can shrink the size
> of the second column to match the width of the data in it?,
>
> tsm: xxxxxxx>select cast(node_name as CHAR(15)) as Node,cast(filespace_name
> as CHAR(15)) as FS,cast(volume_name as CHAR(8)) as Volume from volumeusage
>
> NODE                 FS                                  VOLUME
> ----------------     -------------------------------     ---------
> xxxxxxx              \\xxxxxxxxxx\x$                     xxxxxx
> ...
>
> TSM Server is v6.3.3.1 running on Windows Server 2008 R2. Admin client is
> 6.4.0.1.
>
> Regards
> Neil Schofield
> Technical Leader.
> Yorkshire Water
>
>
>  ----------------------------------------
>
> 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
>

Reply via email to