Append Stock Ledger Information to History Tables (salapnd)
Module Name |
salapnd.pc |
Description |
Append Stock Ledger Information to History Tables |
Functional Area |
Stock Ledger |
Module Type |
Admin |
Module Technology |
ProC |
Catalog ID |
RMS335 |
Wrapper Script |
rmswrap_multi.ksh |
Design Overview
The purpose of this program is to move data from the staging table for transaction data into the historical transaction data table. This requires placing a lock on the staging table to ensure that no new data will be added to it while the movement is occurring (to handle trickling or real-time processing), moving the data to the historical table, and finally truncating the data from the staging table.