Allowed uses: By Commit, MDX, SQL
*WRITE_TO_FAC2
This instruction triggers the posting of the results directly to the short-term data storage table (tblFAC2) of the application set.
If this instruction is found in a given COMMIT section, the records to be posted end up directly in the FAC2 table rather than real-time data storage (the write back table).
This mechanism can be helpful when a rules execution may generate a significant amount of new records, leading to a fast increase in the content of the write back table, which in turn would cause a significant degradation of performance in all I/O activities.
Note
At the end of the rules execution a processing of the FAC2 partition is required, to make the results of the logic available to the application. This can be done adding an appropriate task at the end of the DTS package that executed this type of rule. Alternatively the *PROCESS_FAC2 instruction can be used. See *PROCESS_FAC2.