Can I substitute table in FROM with a hosted variable?

Published on InterSystems Developer Community (https://community.intersystems.com)

Question

Evgeny Shvarov · May 19, 2020

Haven't found this in the documentation. I want:

&sql(SELECT name INTO :var FROM :table)

Is it possible?

#ObjectScript #SQL #InterSystems IRIS

Source URL:https://community.intersystems.com/post/can-i-substitute-table-hosted-variable