Check Received Statistics

Public Science CAL datasets:

select count(*),cdrom
from hstmisc..dads_received d, hstdads..archive_data_set_all a
where curr="Y"
and a.ads_data_set_name = d.dataset_name
and a.ads_archive_class = d.archive_class
and a.ads_generation_date = d.gen_date
and a.ads_release_date < "31 mar 1999"
and science in ("Y","A","S") 
group by cdrom
compute sum(count(*))
go
             cdrom 
 ----------- ----- 
       22779       
         150 C     
      216966 Y     
 sum               
 ===========       
      239895       

That is, 9.5% of all the public science datasets are not retrievable.



select count(*),substring(d1.dataset_root,1,1)
from dads_received d1, dads_received d2
where d1.dataset_name = d2.dataset_name
and d1.archive_class=d2.archive_class
and d1.curr="Y" and d2.curr!="Y"
and d1.cdrom=" " and d2.cdrom!=" "
group by substring(d1.dataset_root,1,1)
compute sum(count(*))
go
               
 ----------- - 
          23 F 
         353 N 
         354 O 
         902 U 
          67 W 
          32 X 
         415 Y 
         115 Z 
 sum           
 ===========   
        2261