SQL | InterSystems Developer Community

Question

How to access a stream property in a SQL trigger

I have an IRIS persistent class with a %Stream property whose value is a JSON object. I'd like to use a SQL trigger to pull some value out of the JSON and persist it in another property, for easy querying and indexing. See below for a minimal example:

#ObjectScript #SQL #InterSystems IRIS

0 2

0 55

Question

Martin Nielsen · May 2

SQLCODE: -99 when executing dynamic SQL on specific properties

Hi, I am unsure how to remove this restriction; when I am performing dynamic SQL using ##class(%SQL.Statement).%ExecDirectNoPriv(, .query, args...)

It works fine, but the moment I add specific properties from the persistent class I am performing the select on into the WHERE clause, I get: ERROR #5540: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation. Despite using %ExecDirectNoPriv, I've tried with prepared statement as well, exact same situation.

#SQL #InterSystems IRIS

0 3

0 57

Question

Ashok Kumar T · May 8

Embedded SQL result issues inside %ZLANGC routine

Hello Community,

I executed the below query in the %ZLANGC00.mac routine. It returns results when using dynamic SQL, but not with embedded SQL(returns 0).

#ObjectScript #SQL #InterSystems IRIS #InterSystems IRIS for Health

0 4

0 40