Get HTML - get_html_ctl_d.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: get_html_ctl_d.sql -- -- Author: Steve Roach -- -- Date: 25-JUL-2006 -- -- Version: 01.00 -- -- -- -- Description: Create Control Database seed data for sub-system GET_HTML. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 30-JUL-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DELETE FROM html_page_access WHERE run_no IN (SELECT run_no FROM mapping_histories WHERE mapping_library IN ('M_H2S_RAW_HTML' ,'M_S2S_PARSE_HTML')); DELETE FROM mapping_histories WHERE mapping_library IN ('M_H2S_RAW_HTML' ,'M_S2S_PARSE_HTML'); DELETE FROM mapping_libraries WHERE mapping_name IN ('M_H2S_RAW_HTML' ,'M_S2S_PARSE_HTML') / COMMIT / INSERT INTO mapping_libraries ( mapping_name ,rep_from ,rep_to ) VALUES ( 'M_H2S_RAW_HTML' ,'EXTERNAL_HTML' ,'STAGING' ) / INSERT INTO mapping_libraries ( mapping_name ,rep_from ,rep_to ) VALUES ( 'M_S2S_PARSE_HTML' ,'STAGING' ,'STAGING' ) / COMMIT /