thank you for your advised,
suttip

> -----��ͤ����鹩�Ѻ-----
> �ҡ:    Mecki M. [SMTP:rmeschon AT OTELO.IBMMAIL DOT COM]
> �������:     18 ���Ҥ� 1999 07:46
> �֧:    ADSM-L AT VM.MARIST DOT EDU
> ����ͧ:   Antwort: How do I know chain of tape volume
> 
> Hi Suttinun,
> 
> with
>      select FILE_NAME from contents where volume_name='n00001' and
> segment<>'1/1'
> you'll find the name of the file spread over two volumes.
> 
> And with
>      select VOLUME_NAME from contents where FILE_NAME='see.above' and
> segment='2/2'
> you'll find the other volume.
> 
> Regards
>      Mecki