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 ?
Comments
Starting with 2020.1 Universal Query Cache is used for all SQL statements.
Have you encountered an issue with it?
Pinging @Benjamin De Boe
See also this DC article about the subject.
What exactly do you want to "switch back" and why?
the main reason is the get inspiration for my own Custom Class Queries
Check Retain cached query source option?
do you refer to this ????
$classmethod("%sqlcq."_$tr($namespace,"%_-$@:/\[]^ ","pudsssssssss")_".xETs3uMe2Ehn2LY5inuZiK4xgwnS","%New")this seems like developers forcing out of embedded SQL
Try the following:
- enable "Retain cached query source" as described above
- compile your class/project with addition flags "k /compileembedded=1" (see Validating Embedded SQL Code)
- open the code of the generated program from the Studio or System Portal like %sqlcq.[YOURNAMESPACE].xETs3uMe2Ehn2LY5inuZiK4xgwnS.1.int Note: at the same time, do not forget to specify checkbox for system items
- Profit!
Thanks.
This makes retrieval of generated code better.
But attractive would be exaggerating.