0
155
Question Padmaja Konduru · Apr 11, 2024

Select View throwing Error "References to an SQL connection must constitute a whole subquery"

#InterSystems IRIS #SQL

Hi,

I have created view from External table joins internal persistent table. Create VIEW worked but Select * from Viewxxx throwing error.

"References to an SQL connection must constitute a whole subquery"

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE….

Could it possible to create view with external db table with local persistant table and to access it?

please suggest any thoughts on it..

Thanks,

Product version: IRIS 2022.3
Discussion (2)2
Log in or sign up to continue

Comments

Luis Angel Pérez Ramos · Apr 12, 2024

The documentation is pretty clear, you have to include the external table as a subquery:

FROM Sample.Person,(SELECT * FROM Mylink.Person)

That means that you have to modify your view to use the external table in that way. 

0
Padmaja Konduru  Apr 15, 2024 to Luis Angel Pérez Ramos

Thank you Luis, I have updated query and it is working fine. Thank you so much for your response.

0