The DRDA Service doesn't support the WITH common_table_expression clause and returns the following error message:
<ObjectName> IS AN UNDEFINED NAME. SQLSTATE=42704 SQLCODE=-204
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This issue is fixed in the following cumulative update for Host Integration Server:
Learn about the terminology that Microsoft uses to describe software updates.