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
===============================================================================