Re: How to find out what tape's a client data are on ?
2001-03-02 00:19:47
Subject: |
Re: How to find out what tape's a client data are on ? |
From: |
"Walker, Lesley R" <lesley.walker AT EDS DOT COM> |
Date: |
Fri, 2 Mar 2001 18:16:27 +1300 |
> Just out of curiosity, since I've only casually been following
> this thread, was there a specific reason for the "group by"
> clause?
>
> I think what is desired is simplly an "order by" clause, e.g.
Well, I'm really confused now.
I came up with my own version of the query:
select distinct volume_name,stgpool_name
from volumeusage
where node_name='FOO'
and that produces an answer:
VOLUME_NAME STGPOOL_NAME
------------------ ------------------
ITF010 CPITFPOOL
ITF010 CPITFPOOL
ITF013 CPITFPOOL
ITF018 CPITFPOOL
ITF026 CPITFPOOL
ITF001 ITFPOOL
ITF003 ITFPOOL
ITF004 ITFPOOL
ITF014 ITFPOOL
ITF025 ITFPOOL
ITF027 ITFPOOL
ITF028 CPITFPOOL
ITF006 ITFPOOL
ITF002 CPITFPOOL
BUT if I add "order by stgpool_name" it doesn't show all the tapes - eg:
VOLUME_NAME STGPOOL_NAME
------------------ ------------------
ITF010 CPITFPOOL
ITF010 CPITFPOOL
ITF001 ITFPOOL
So what's going on here?
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: How to find out what tape's a client data are on ?, (continued)
- Re: How to find out what tape's a client data are on ?, Shekhar Dhotre
- Re: How to find out what tape's a client data are on ?, Andy Raibeck
- Re: How to find out what tape's a client data are on ?, David Longo
- Re: How to find out what tape's a client data are on ?, ALAN DAVENPORT
- Re: How to find out what tape's a client data are on ?, Allen Barth
- Re: How to find out what tape's a client data are on ?, Shekhar Dhotre
- Re: How to find out what tape's a client data are on ?, David Longo
- Re: How to find out what tape's a client data are on ?, Shekhar Dhotre
- Re: How to find out what tape's a client data are on ?,
Walker, Lesley R <=
- Re: How to find out what tape's a client data are on ?, Sharp, Neil (London)
- Re: How to find out what tape's a client data are on ?, Steve Hicks
- Re: How to find out what tape's a client data are on ?, Andy Raibeck
- Re: How to find out what tape's a client data are on ?, Prather, Wanda
- Re: How to find out what tape's a client data are on ?, Walker, Lesley R
|
|
|