Magic xpa Transactions and AS/400 Files (Magic xpa 3.x)
To perform transactions in Magic xpa using IBM i tables, you should:
-
Set the ISAM Transactions setting in Options/Settings/Environment/Multi-User to Yes.
-
Specify TRANSACTIONS=Y in the SQL Database Information property for the IBM i database either at:
The database level on the SQL tab of the Database Properties dialog box or
The table level on the SQL tab of the Data Source properties dialog box
-
Use Magic xpa programming as usual.
The TRANSACTIONS=Y keyword triggers the following new functions:
-
Creates a journal receiver and journal if they do not already exist. The file name is used for both the receiver and the journal.
-
Sends a message to QSYSOPR
-
Starts journal PF if a file is a physical file. Starts a journal access path if a file is logical file
-
Opens files for a COMMIT statement