Hi, I'm thank you very much for your reply....but I resolve it.

The solution for the select command is last_use is null.
With last_use != 'Data' or another sintax It doesn't work correctly.
Thank you very much.

Alessio Prodon






Alex Paschal <AlexPaschal AT FREIGHTLINER DOT COM> il 28/09/2000 00.38.36

Per favore, rispondere a "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Per:  ADSM-L AT VM.MARIST DOT EDU
Cc:    (ccr: Alessio Prodon/Centro di Gestione/G-Net/IT)
Oggetto:  Re: Oggetto: Re: Select ??????????




Hi, Pieter.  Actually, if I remember right, this is not a TSM bug, this is
the way SQL works.  If you try building this same select statement, say, in
Crystal Reports pulling from a "real" database, you would have to use
something like.

[...] where last_use is null or last_use != 'Data'

I hope this helps.

Thanks much,

Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
(503) 745-5091 fax