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