A SET TRANSACTION statement is not permitted within a SQL
  function definition

  Explanation:  Neither a SET TRANSACTION nor a START TRANSACTION
  statement is permitted within an SQL function.

  User Action:  These statements may only be used in a SQL stored
  procedure, or an anonymous compound statement (also known as a
  multi-statement procedure).

  User Action:  Define the SQL function without any TRANSACTION
  control statements.