continuation conversation :
Would you run the following query to get the list of files RAA believes are MAIN programs, but are used as includes (in other main program files) ?
(Send the results please)
I want to get a sense of size and accuracy.
select substr(file.file_name, 1, 32)
from dmh.dmh_cu_include ci
join dmh.dmh_file file
on ci.member_id = file.fi le_id
where ci.incl_type_id = 0
and ci.member_id in (select member_id
where incl_type_id != 0)
result (attach file) of this query for all sites because I do not know how to limit to a site starting from your query