dwh/Package/t24dwh_insert.sql
2024-01-12 15:25:44 +07:00

15 lines
485 B
SQL

SET FEEDBACK OFF
DEFINE user_sys = 'SySTeM'
PROMPT importing table external_data_tab...
INSERT INTO external_data_tab (tab_name, purging_type, modul, purging_field, purging_data_type, purging_filter, load_method, map_name, submodul, ext_tab_name, group_data, txt_filename, seq_process)
VALUES ('T_STMT_DIST_CODE', 'Y', 'T24', null, null, null, 'IU', 'MAP_STMT_DIST_CODE', 'BASIC', 'T_STMT_DIST_CODE_EXT', '1', 'T_STMT_DIST_CODE.TXT', 18);
COMMIT;
SET FEEDBACK ON
PROMPT DONE.