Hi ..
Thanks much for your reply.. I hope this is what i need,
Anyway my requirement is , we have DRM , and when we compare the actual tapelist that were residing in the offsite with the tapes that were actually present in the offsite , we could see a mismatch . ie many tapes were not there in the q drm status , but present in the offsite which were not called by automatically. and we are doing that manually and calling those tapes as scratch.so i needed a select command to sort out the tapes.thanks again..