Show TOC

Syntax documentation*WRITE_TO_FAC2 Locate this document in the navigation structure

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 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.

End of the note.