The sharing mode indicates whether a file is to participate in file sharing and record locking.
Three sharing modes are available:
For a full table showing the results when an OPEN is attempted in the various sharing modes, see the table Opening available shared files that are currently open by another file connector in the topic The OPEN Statement.
To specify one of these sharing modes, use the SHARING phrase either on an OPEN statement or as part of the SELECT clause. The SHARING phrase in the OPEN statement overrides that in the SELECT clause.
If you do not include the SHARING phrase in either the SELECT clause or the OPEN statement, the sharing mode is determined when the first of the following conditions is satisfied:
| If You Specify ... | Sharing Mode |
|---|---|
| The WITH LOCK phrase on the OPEN statement | SHARING WITH NO OTHER |
| The LOCK MODE IS EXCLUSIVE phrase in the SELECT clause | SHARING WITH NO OTHER |
| Either the LOCK MODE IS MANUAL phrase or the LOCK MODE IS AUTOMATIC phrase in the SELECT clause | SHARING WITH ALL OTHER |
| The open mode as OUTPUT, I-O or EXTEND | SHARING WITH NO OTHER |
| The open mode as INPUT and the configuration option OPENINPUTSHARED set to OFF | SHARING WITH READ ONLY |
| The open mode as INPUT and the configuration option OPENINPUTSHARED set to ON | SHARING WITH ALL OTHER |