Salesforce

Table Access and Share Mode (Magic xpa 4.x)

Printable View
« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Table Access and Share Mode (Magic xpa 4.x)

In Magic xpa you open a table with both an Access mode and a Share mode as specified in the Main Source properties. When opening a table, Magic xpa performs some internal tasks, such as getting the structure of the table from the database, checking for the table’s existence, and more. If Magic xpa locks are used, relevant information is written in the mglock file.

When working with RDBMSs, there is no Open File or Open Table command. Therefore, the Access and Share modes have almost no meaning except for the following cases:

  • Share is None – The SQL gateway sends a Lock Table command to the SQL database. This is done only in Oracle.

  • If the Access mode is READ, the Share mode is WRITE, and the table is a linked table when a lock is requested, the records of the linked tables will not be locked.
    If the Access mode is WRITE, Magic xpa assumes that the linked table may also be updated, and a lock is issued for it as well.

Reference
Attachment 
Attachment