ADSM-L

Re: [ADSM-L] Query syntax

2015-02-04 09:00:46
Subject: Re: [ADSM-L] Query syntax
From: Jeanne Bruno <JBruno AT CENHUD DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 4 Feb 2015 13:58:55 +0000
Nice one!

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Reese, Michael A (Mike) CIV USARMY 93 SIG BDE (US)
Sent: Wednesday, February 04, 2015 8:53 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Query syntax

select char(node_name,50) as "Node Name", cast(client_version as char) || '.' 
|| cast(client_release as char) || '.' || cast(client_level as char) || '.' || 
cast(client_sublevel as char) as "Version" from nodes

________________________________
From: ADSM: Dist Stor Manager [ADSM-L AT VM.MARIST DOT EDU] on behalf of David 
Ehresman [david.ehresman AT LOUISVILLE DOT EDU]
Sent: Wednesday, February 04, 2015 8:36 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Query syntax

What is the select statement syntax for concatenating 
client_version,client_release,client_level,client_sublevel from the nodes table 
into a single string, e.g. 7.1.1.3?

David

<Prev in Thread] Current Thread [Next in Thread>