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 [EMAIL PROTECTED]
