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
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 a...@ufl.edu
To:
ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
Cc:
Neil Schofield neil.schofi...@yorkshirewater.co.uk
Date:
17/04/2013 14:59
Subject:
Re: [ADSM-L] SELECT statements
-Neil Schofield wrote: -
The fact that only the FILESPACE_NAME column is twice as wide as it
should be makes me wonder if it's a bug?
It probably has something to do with the possible occurrence of
Unicode characters outside the ASCII character set in filespace
names.
Thomas Denier
-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
Wanda
You can also do:
select substr(filespace_name,1,20) from filespaces
and get only 20 chars back.
Well that's interesting because it makes the problem worse! Using either
CAST or SUBSTR truncate my data to N characters, but CAST gives me a
column width of (N+1) for NODE_NAME and (2N+1)
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Neil
Schofield
Sent: Wednesday, April 17, 2013 6:25 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SELECT statements and column widths
Wanda
You can also do:
select substr(filespace_name,1,20
. At all.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Prather, Wanda
Sent: Thursday, April 18, 2013 12:25 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SELECT statements and column widths
Well that is odd -
I don't know why 2n+1
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
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.ukwrote:
I'm in the throes of an upgrade from TSM Server 5.5 to 6.3 and have had a
bit of a