Application of Fourth Method of Dynamic SQL in Data Synchronization Module
Zhishu Li · Ordnance Industry Automation · 2004
Data of front and background databases for information system of medical insurance were processed synchronously with fourth method of dynamic SQL. According to log and timestamp methods, a list syn_data was respectively set up in front and background databases. The data transfer between source database and target database was implemented with middle ware For-TPCS. After selecting list item, variable number, length and data type, dynamic SQL sentence was built through that each list syn_data was inserted, modified and deleted, and data synchronous processing was realized with it.