Hi,

     I'm trying to get the volune name for a file i want to restore, i tried the
following query (i took an hour to run)
SELECT VOLUME_NAME from contents where FILE_NaME='/IWSP6/PRODUCTS/ODI331/SYSTEM/
ETHEROSM.LAN'

Is There a faster way to find out on wich volume the data reside?

I'm using AS/400 server 3.1.0.7

Jonathan Lepage