Your code looks like a ClassQuery.   %Library.Query

This is not a Stored Procedure  :=>  a ClassMethod ...[SqlProc,SqlName=anyname]  

and everything happens inside this ClassMethod
you run is by CALL PROCEDURENAME

I use it since Caché 2014.* at least.
this just the latest documentation.
What's the purpose of the semicolon ?  SELECT Name,Home_State FROM Sample.Person   ;
for TEMP table see: https://docs.intersystems.com/iris20242/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_createtable#RSQL_createtable_desc_temp

Before collecting all pieces in the Stores Procedure
I'd suggest to test you queries isolated im SMP or from terminal in SQL shell

UNderstand a STORED PROCEDURE as a special case of a ClassMethod
using CREATE PRODURE .......LANGUAGE OBJECTSCRIPT
You can write it with all specials you need
see docs: https://docs.intersystems.com/iris20242/csp/docbook/Doc.View.cls?KEY=RSQL_createprocedure

 

Thanks! A great summary!

@Mary George 

there is one.

I just posted a cross namespace cross CLS, MAC; INT, INC search
https://community.intersystems.com/post/code-scanner

It's pretty fast just using COS and Globals.  No class.

Congrats:
I like your code example that demonstrates deep understanding of the DB concept.
 💪

From docs:

tformat = 1  >>> Express time in the form "hh:mm:ss" (24-hour clock).

W $ZTIME(338,1,)
00:05:38

W $ZTIME(338+43200,1)
12:05:38

My guess: You look for this

​​​​​​​W $tr($ZTIME(338,3),"AM")
12:05:38

set time="2023-09-28T20:35:41Z"
write $TRANSLATE(tine,"-:TZ")

20230928203541

Do you look for a kind of LOGGING ?

👍💪

iris | 08/15/24-05:47:48:778 (828) 3 [Utility.Event] Error while moving data directories

ERROR #5001: Cannot create target: /shared/durable/

You may have some file protection issue

on Windows use  $$$installdir\bin\iris.exe 

• iris stop <instance-name>
• iris start <instance-name>

for instance-name use iris list