Specifies that rows are skipped when incompatible locks that would block the progress of the statement are held on the rows by other transactions.
UPDATE TABLE1 AS t1
SET t1.Column1 = 1
WAIT FOR OUTCOME;
UPDATE EMPLOYEE
SET JOB=NULL, SALARY=0, BONUS=0, COMM=0
NOWAIT;
UPDATE PROJECT P
SET P.LOCATION = D.LOCATION
FROM DEPARTMENT D
WHERE P.DEPTNO = D.DEPTNO
WAIT 10;
UPDATE PUBLIC.TABLE1 AS t1
SET t1.Column1 = 1
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. UPDATE WAIT FOR OPTION **
-- WAIT FOR OUTCOME
;
UPDATE PUBLIC.EMPLOYEE
SET JOB=NULL, SALARY=0, BONUS=0, COMM=0
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. UPDATE NO WAIT OPTION **
-- NOWAIT
;
UPDATE PUBLIC.PROJECT P
SET P.LOCATION = D.LOCATION
FROM DEPARTMENT D
WHERE P.DEPTNO = D.DEPTNO
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. UPDATE WAIT TIME SEC OPTION **
-- WAIT 10
;