Only one wait mode may be specified for a transaction

  Explanation:  You specified both wait modes in a DECLARE
  TRANSACTION statement.

  User Action:  Specify either WAIT or NOWAIT, not both, in a
  DECLARE TRANSACTION statement.