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

Home > What happened to embedded SQL ?

Question
jaroslav rapp · Dec 3, 2021

What happened to embedded SQL ?

When i use &sql(SELECT ......)  in Cache I can watch the generated code
In the generated .int code and see what is happening.
Just with my normal rights

Now in IRIS I have just 4 line calling some class %sqlcq.***
With enough rights i find there is no such class but the generated .int routine
%sqlcq.IRISAPP.xEZgUjdXCCgQdZQPpRdOye1Ci2ue.1
That holds the code that i had in my .int on Cache

Can i switch this back somehow ?

#SQL #Caché #InterSystems IRIS
Product version: IRIS 2021.1

Source URL:https://community.intersystems.com/post/what-happened-embedded-sql