Tomas,
The following select statement will give you exactly what you want.
select node_name as NODENAME,sum(case when substr(stgpool_name,1,1) in ('T')
then logical_mb else 0 end) as PRIMARY_OCC,sum(case when
substr(stgpool_name,1,1) in ('C') then logical_mb else 0 end) as COPY_OCC from
occupancy group by node_name
Regards, Samiran Das
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Tomáš Hrouda
Sent: Friday, February 11, 2005 5:19 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Nested select
Hi all,
I have problem with select command, maybe SB had solve similar problem
sometimes. What I need to do: select from occupancy table where I want to have
on ONE row : 1st column - nodename 2nd column - sum logical_mb accross stgpools
like "T%" (primary pools) for this node 3rd column - sum logical_mb accross
stgpools like "C%" (copy pools) for this node
I think this is example for application of nested select commands and I know,
that TSM DB selects are reduced set of SQL92 and SQL93 standard. I was not able
to collect appropriate command, so I want to ask anybody, if is it ever
possible in TSM to do that.
Any idea will be appreciated.
Regards
Tomas Hrouda
Storage Specialist
HTD s.r.o. Praha
CZECH REPUBLIC
throuda AT htd DOT cz
--------------------------------------------------------
If you are not an intended recipient of this e-mail, please notify the sender,
delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------
|