The following table indicates the record locking strategy that will be used for a file when it has been previously opened. The leftmost column indicates the strategy in use after the file was first opened. The cells in the table indicate the record strategy that will be used when the file is opened for a second or subsequent time, and may be different to the actual strategy requested by the OPEN. A column containing N/A indicates that the requested strategy was incompatible with the strategy already in effect for the file, and will result in the OPEN failing with a 9/100 file status (invalid operation):
| First File Open Record Locking Strategy | Second and Subsequent File Open Record Locking Strategy Intent | |||||||||
| Transactional | Non-transactional | |||||||||
| Same Process | Different Process | Same Process | Different Process | |||||||
| Table (intent) | Database (intent) | In-memory(intent) | Table (intent) | Database (intent) | In-memory(intent) | Table (intent) | In-memory (intent) | Table (intent) | In-memory (intent) | |
| Table | Table (used) | Table (used) | Table (used) | Table (used) | Table (used) | Table (used) | Table (used) | Table (used) | Table (used) | Table (used) |
| Database | Database (used) | Database (used) | Database (used) | Database (used) | Database (used) | Database (used) | N/A | N/A | N/A | N/A |
| In-memory | N/A | N/A | N/A | N/A | N/A | N/A | In-memory (used) | In-memory (used) | N/A | N/A |