User bio
404 bio not found
Member since Mar 2, 2016
Posts:
Warlin has not published any posts yet.
Replies:

Assuming this is query, your CASE statements will only populate the first item that matches a condition. In this example all checked conditions match either 'R' or 'A'  and 'PROPS DECISIONED' also matches both of them. Depending on what you're trying to do with the query, a simple solution would be to move condition for 'PROPS DECISIONED' to be the last in the list. That way any of the more granular conditions would be picked first and 'PROPS DECISIONED' works as a "catch all/else" condition.

From your output it's not clear if you're in the SQL Shell. You need to be in the Shell to execute the EXPLAIN command

Warlin Garcia · Jul 25, 2025 go to post

a) Haven't seen this issue before so not sure what might be trying to stop/interrupt the process

b) The %sqlcq.{namespace}.cls375.1 is the INT version. If you can't find it then your system is not configured to keep generated source. 

One way to see the code in this situation, assuming you can make code changes in that environment, is to create a routine with the target SQL using embedded SQL and you'll see in most cases the same code that should be in the *.cls### routines. 

c) One way to get it according to documentation https://docs.intersystems.com/iris20252/csp/docbook/Doc.View.cls?KEY=GW…

Certifications & Credly badges:
Followers:
Warlin has no followers yet.
Following:
Warlin has not followed anybody yet.