Which file share mode is used by a directory access server, when reading the contents of files? And is the Read Only clause in the create statement influencing the used mode?
asked 26 May '14, 06:08
I've scanned the low-level Directory Access Server code and here is what I see:
The exact behaviour may vary depending on how the platform handles the open flags.
Note that the READ ONLY state of the proxy table only influences the high-level code within the database server: if a table is marked as read only then the server denies any attempt to write/update contents to the table. It does not affect the open flags that are used.
Disclaimer: The above is what SQLA 16 does currently (as of today when I looked at the code). Other versions may be slightly different (although I doubt it), and future versions may also differ.