The following statement starts a transaction with the following characteristics: o Default transaction (no user-specified transaction handle) o READ_WRITE access o CONSISTENCY mode o WAIT option (by default) o Will evaluate the constraint JOB_CODE_REQUIRED when the DML statement is executed o Will attempt to reserve the relation JOBS for SHARED_WRITE access
1 – C Statement
START_TRANSACTION READ_WRITE ON pers USING (READ_WRITE CONSISTENCY EVALUATING pers.JOB_CODE_REQUIRED AT VERB_TIME RESERVING JOBS FOR SHARED WRITE);
2 – Pascal Statement
START_TRANSACTION READ_WRITE ON pers USING (READ_WRITE CONSISTENCY EVALUATING pers.JOB_CODE_REQUIRED AT VERB_TIME RESERVING JOBS FOR SHARED WRITE);