Michael's is very straght forward, but you may need to change "SUB LEVEL" to "SUBLEVEL" if your command line editor does not like spaces in the text.
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Hoang, Michael D CONT (NETS) Sent: Monday, December 02, 2002 11:59 AM To: [EMAIL PROTECTED] Subject: Re: Client version stored in Database? Try this one.... select node_name as "NODES", platform_name as "Platform", client_version as "VERSION", client_release as "RELEASE", client_level as "LEVEL",client_sublevel as "SUB LEVEL" from nodes -mdh -----Original Message----- From: Mark D. Rodriguez [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:49 PM To: [EMAIL PROTECTED] Subject: Re: Client version stored in Database? Zlatko Krastev/ACIT wrote: >select cast(CLIENT_RELEASE as char) concat '.' concat cast(CLIENT_LEVEL as >char) concat '.' concat cast(CLIENT_SUBLEVEL as varchar(2)) concat ' for ' >concat PLATFORM_NAME concat '/' concat CLIENT_OS_LEVEL as >"----------------------------------------" from nodes > >Zlatko Krastev >IT Consultant > > > > Zlatko, That is a very cool little select. However you missed the client version so here is my little addition. select cast(CLIENT_VERSION as char) concat '.' concat cast(CLIENT_RELEASE as char) concat '.' concat cast(CLIENT_LEVEL as char) concat '.' concat cast(CLIENT_SUBLEVEL as varchar(2)) concat ' for ' concat PLATFORM_NAME concat '/' concat CLIENT_OS_LEVEL as "----------------------------------------" from nodes -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. ============================================================================ === MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE ============================================================================ ===