What happened to embedded SQL ?

Question

Question

jaroslav rapp · Dec 3, 2021

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 ?

Product version: IRIS 2021.1

Discussion (7)1

Log in or sign up to continue

Vitaliy Serdtsev · Dec 7, 2021

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!

0 0

score 2 · Answer 1 · 2021-12-05T13:36:00-05:00

Starting with 2020.1 Universal Query Cache is used for all SQL statements.

Have you encountered an issue with it?

Pinging @Benjamin De Boe

score 1 · Answer 2 · 2021-12-06T03:30:18-05:00

Benjamin De Boe · Dec 6, 2021

See also this DC article about the subject.

What exactly do you want to "switch back" and why?

1 0

score 0 · Answer 3 · 2021-12-06T08:40:45-05:00

jaroslav rapp · Dec 6, 2021

the main reason is the get inspiration for my own Custom Class Queries

0 0

score 0 · Answer 4 · 2021-12-06T13:22:58-05:00

Eduard Lebedyuk · Dec 6, 2021

Check Retain cached query source option?

0 0

score 0 · Answer 5 · 2021-12-06T14:32:41-05:00

do you refer to this ????

$classmethod("%sqlcq."_$tr($namespace,"%_-$@:/\[]^ ","pudsssssssss")_".xETs3uMe2Ehn2LY5inuZiK4xgwnS","%New")

this seems like developers forcing out of embedded SQL

score 0 · Answer 6 · 2021-12-07T06:49:49-05:00

jaroslav rapp · Dec 7, 2021

Thanks.

This makes retrieval of generated code better.
But attractive would be exaggerating.

0 0