--> ANR2900W The character string '32' was truncated during assignment.

Use "cast(client_level as char(2))" or "cast(client_level as varchar(2))" 
instead.

Zlatko Krastev
IT Consultant






Paul van Dongen <paul AT VANGUARD-IT.COM DOT BR>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
02.12.2002 14:10
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        RES: Client version stored in Database?


Doug,

  maybe this one helps


select node_name,cast(client_version as char) || cast(client_release as
char) || cast(client_level as char) as Client from nodes




--
Paul Gondim van Dongen
Engenheiro de Sistemas
MCSE
Tivoli Certified Consultant - Storage Manager
VANguard - Value Added Network guardians
http://www.vanguard-it.com.br
Fone: 55 81 3225-0353


-----Mensagem original-----
De: Nelson, Doug [mailto:DNelson AT CHITTENDEN DOT COM]
Enviada em: Monday, December 02, 2002 14:01
Para: ADSM-L AT VM.MARIST DOT EDU
Assunto: Client version stored in Database?


Can I issue a query to tell the version of TSM client software on each
node?

                                        Thanks, Doug

Douglas C. Nelson
Distributed Computing Consultant
Alltel Information Services
Chittenden Data Center
2 Burlington Square
Burlington, Vt. 05401
802-660-2336