From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lisa Laughlin >Thanks Richard-- I was hoping it wasn't one of THOSE select >statements-- I started > >tsm: TSM_HQ_2>select deactivate_date, filespace_name, type, ll_name, >hl_name,dea >ctivate_date, class_name, state, backup_date,node_name from >backups where >NODE_N >AME='GHDATA01DISKGROUP2' order by BACKUP_DATE
Also, try to limit the select by setting delimiters on the filespace_name, type, and backup_date. -- Mark Stapleton