Subqueries are not allowed in queries moved by CREATE TRANSFER

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

  User Action:  Re-enter the statement without the subquery.