InterSystems IRIS TSQL Code 7405 Heterogeneous queries require the ANSI_N

In this post, you’ll learn about the SQL error code 7405 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform

Error Code :

7405

Reason for the Error code 7405 in InterSystems IRIS DBMS

Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.

Leave Your Comment