Page History
...
DBMS_RECORD_LOCKED only checks the status of the file, which is the subject of the command. If in the example batch control logic is used and the batch control record was locked *DBMS_RECORD_LOCKED would return a value of 'N'. The same applies to any files used by triggers. If the record locked status is to be checked for a file used by a trigger the above logic should be inserted into the trigger function.
Portability Considerations | IBM i: Automaticaly unlocks a file after a certain period of time. Non-IBM i: This feature is emulated and disabled by default. For further details, refer to Lock Timeout. |