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);