Salesforce

Magic xpa Transactions and AS/400 Files (Magic xpa 3.x)

Printable View
« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Magic xpa Transactions and AS/400 Files (Magic xpa 3.x)

Transaction Processing

To perform transactions in Magic xpa using IBM i tables, you should:

  1. Set the ISAM Transactions setting in Options/Settings/Environment/Multi-User to Yes.

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

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

Reference
Attachment 
Attachment