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
|
