Multiple LOCKING modifiers can precede a request if it is necessary to lock more than one object at the same time, for example:
LOCKING TABLE employee FOR ACCESS LOCKING TABLE department FOR ACCESS SELECT name, loc FROM employee, department WHERE (empno=mgrno);