Can I substitute table in FROM with a hosted variable?

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

Home > Can I substitute table in FROM with a hosted variable?
Question
Evgeny Shvarov · May 19, 2020

Can I substitute table in FROM with a hosted variable?

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

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

Is it possible?

#ObjectScript #SQL #InterSystems IRIS
00
2 0 7 175
Log in or sign up to continue
Source URL: https://community.intersystems.com/post/can-i-substitute-table-hosted-variable