This topic describes how WebFOCUS Maintain ensures transaction integrity at the application level. At the data source level, each database management system (DBMS) implements transaction integrity in its own way. For more information, see your DBMS vendor documentation for DBMS-specific information. For FOCUS data sources, this DBMS-specific information is presented in Ensuring Transaction Integrity for FOCUS Data Sources. For DB2, you can find some suggested strategies for writing Maintain transactions to DB2 data sources in Ensuring Transaction Integrity for DB2 Data Sources. For many other types of data sources, you can also apply the strategies described in Ensuring Transaction Integrity for DB2 Data Sources, changing DBMS-specific details when necessary.
A banking application would define a transfer of funds from one account to another as one logical transaction comprising two update operations:
To process a logical transaction, follow these steps:
You can set some native DBMS parameters using the SYS_MGR.FOCSET command. For more information, see the Maintain Language Reference manual. You can also set some native DBMS parameters through FOCUS. See your server documentation.
For FOCUS data sources, you must set the COMMIT server parameter to ON, and issue a USE command to specify which FOCUS Database Server will manage concurrent access to the data source. For more information, see Ensuring Transaction Integrity for FOCUS Data Sources.