TSM server 6.2.3.100 SQL oddity

Rigido

ADSM.ORG Senior Member
Joined
Apr 21, 2006
Messages
151
Reaction score
7
Points
0
Location
Rome, Italy
Hi,
I have a little script to show nodes properties but every try to cut TCP_NAME or TCP_ADDRESS columns result in a "doubled" size column:
Code:
>tsm: TSM_ACEA_V6>select rpad(TCP_NAME, 15), rpad (TCP_ADDRESS, 15) from nodes

Unnamed[1]                       Unnamed[2]
-------------------------------  -------------------------------
EWPASPROD                        10.65.62.42
EWPASPROD                        10.65.62.42
As you can see, rpad is 15 but column width is 30 char, no problem on TSM v7.1.1.0.
Can someone explain what's going on and if it possible to fix it?

Thanks.
 
Back
Top