it would be great if the issues in building Docker container would be fixed.
so we can touch it and reduce frustration of evaluators first
Actually it is broken, Issues pending since some days
- Log in to post comments
it would be great if the issues in building Docker container would be fixed.
so we can touch it and reduce frustration of evaluators first
Actually it is broken, Issues pending since some days
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
write$translate($justify(input,ln)," ",0)if$d(^|"%SYS"|CONFIG("Namespaces"," "))
forset ns=$o(@$ZR) quit:ns=""write ns,! ; or do whatever you intendThanks! A great summary!
Oh dear !
I started with DSM 1.0 in 1978 and met Terry in the kick-off training for support in Mainard.
It was a great experience to me.
ÍD is an reserved name in IRIS / Ensemble
in fact as you describe it, it is rather a KEY than a typical ID
so this query may serve your needs
SELECT LIST(Value) WHERE KEY=11
SELECT LIST(Value) WHERE KEY=12
demo video added https://youtu.be/JpRJzDNp96c
@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")
20230928203541Do you look for a kind of LOGGING ?
👍💪
with set pSettings("From_Source_Rec_Job","Adapter...
you pass a String literal
assuming the value of your variable str = From_Source_Rec_Job
then set pSettings(str,"Adapter","FTPPort")=2022
should be sufficient
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
Studio has a feature to expand / compress ObjectScript Commands
Advanced Editing
this might be a starting point.
You mentioned IIS.
Are you sure IIS is listening at port 57772 ?
And: http://localhost:57772/csp/sys/UtilHome.csp
looks like the old call to private Apache
on Windows use $$$installdir\bin\iris.exe
for instance-name use iris list
ZENpages load a bunch of dedicated js libraries + scripts in browser for it's communication
Suggestion: create a simple ZEN page and check js libraries and scripts used.
do HELP^%G no blank between P and ^%G
straight Objectscript
not so much need of a SET class in ObjectScript
thanks for the explanation !
Using my previous reply you can do this without need of any custom object:
SAMPLES>read xml
<?xml version="1.0" encoding="UTF-8"?> <session> <session_Id>124364</session_Id> </session>
SAMPLES>set rdr=##class(%XML.Reader).%New()
SAMPLES>do rdr.OpenString(xml)
SAMPLES>zwrite%SAX=1%SAX(1)=2%SAX(1,0)=""%SAX(1,1)="1"""%SAX(1,2)="!>A"%SAX(1,"N","http://www.w3.org/2001/XMLSchema-instance")=1%SAX(1,"d")=4%SAX(1,"d",1)="session"%SAX(1,"d",2)=" "%SAX(1,"d",3)="session_Id"%SAX(1,"d",4)=124364%SAX(1,"n")=1%SAX(1,"n",1)="http://www.w3.org/2001/XMLSchema-instance"%SAX(1,"v")=6
rdr=<OBJECT REFERENCE>[1@%XML.Reader]
xml="<?xml version="1.0" encoding="UTF-8"?> <session> <session_Id>124364</session_Id> </session>"
SAMPLES>edited and simpler