Tuesday, 5 May 2020

SQL Query to fetch loaded HDL dat file records using content id

select hdfl.text hdl_DAT_FILE
from fusion.hrc_dl_data_sets hdds,
fusion.hrc_dl_data_set_bus_objs hddsbo,
fusion.hrc_dl_file_lines hdfl
where 1=1
and hdds.data_set_id = hddsbo.data_set_id
and hddsbo.data_set_bus_obj_id = hdfl.data_set_bus_obj_id
and hdds.ucm_content_id='UCMFA02392156'

No comments:

Post a Comment