Appendix B. Lock Mode During Command Execution

Some HiRDB commands place a resource in an appropriate lock mode automatically. Thus, when multiple programs (including UAPs) are executing concurrently, the user needs to check the command lock mode table and the UAP (SQL) lock table to determine the combination of lock modes. For details about the combinations of lock modes according to the SQL statements executed and the execution environment, see the HiRDB Version 9 UAP Development Guide.

The following lock modes are referenced in the tables in this appendix:

PR: Shared mode
EX: Lock mode
SR: Shared retrieval mode
SU: Shared update mode
PU: Protected update mode
[Figure]: The lock mode during acquisition of check pending status is inherited.
--: Not locked
Organization of this section
B.1 Lock mode for operation commands
B.2 Lock mode for utilities