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