OOOO, open the PMR for adsm level2.
But as I said, better to do "q fi ...", than "select ** contents ... filespaces"
, and only than - for a file.
only than finally i can write smth like:
"set sqldisplaymode wide | select * from archives where node_name='DXXX' \
and filespace_name='DXXX_e' and TYPE='FILE' and \
HL_NAME='\NOTES\DATA2\MAIL\' and LL_NAME='THITCHCO.NSF' \
order by ARCHIVE_DATE"

Try also:

#take a list of objects
echo " Collecting Object IDs"
#dsmadmc -id=xx -password=xx "select DISTINCT object_id from BACKUPS where
node_name='$NODENAME'  \
and filespace_name='$FILESPACENAME'  > $LOGDIR/$HOST.objects"

than do
 "show  bfo 0 <here each id from the *obhects file"
(the bfo - do "sh obj", than do sh node <#of table Objects>".

Sincerely,
Dmitri Chilovich
ADSM Solutions
__________________________________
LN: Dmitri Chilovich/Raleigh/Contr/IBM
E-mail: dmitrich AT us.ibm DOT com
Office phone: 847-240 4654, internal 4654
Pager: 800-946 4646 id 1473134
ADSM USF: Dept.  XVCE, Mngr. Mrs Jane Harris/Raleigh/IBM
IBM Schaumburg, 231 Martingale Rd, IL 60173
____________________________________________________
Private Notes: Please, reply to dima_chilovitch AT hotmail DOT com