HAVING is not allowed in queries moved by CREATE TRANSFER

  Explanation:  The user entered a HAVING clause in a query as
  part of a CREATE TRANSFER statement.

  User Action:  Re-enter the statement without the HAVING clause.