ALL keyword must be specified for union in CREATE TRANSFER Explanation: The user failed to enter the ALL keyword after the UNION keyword in the select expression as part of a CREATE TRANSFER statemetn. User Action: Re-enter the statement with UNION ALL, not just UNION.