Only one degree mode may be specified for a transaction Explanation: You specified both concurrency options (CONSISTENCY LEVEL 2 and CONSISTENCY LEVEL 3) in a DECLARE TRANSACTION statement. User Action: Specify only one option in your DECLARE TRANSACTION statement.