go to post Robert Cemper · Oct 2, 2024 run USER > zn "%SYS" %SYS > ZLOAD JOURNAL %SYS > Print in WebTerminal you just get NOTHINGin normal terminal and iterm you see the code
go to post Robert Cemper · Oct 2, 2024 @Mario Sanchez Macias You missed the point.The essential functionality is to have a total autonomous partition to work in.It was never named so, but it is the real Shell for ObjectScript and its predecessors for >50 years !
go to post Robert Cemper · Sep 26, 2024 simple case:write some lines of ObjectScript in TERMINAL with Functions, ....NO need to compile it, no INT, no MAC, no traces.Just DO it:---or load some INT., apply your changes, run it, forget it no save, no recompile, ...WebTerminal is based on Xecute and compiled codeSame in Studio.
go to post Robert Cemper · Sep 25, 2024 Overall a nice idea.the package still needs some polishing to convince suggestion1: fix issue to build clean dockersuggestion2: re-enable Start+Stop message so uses see it was movingsuggestion3: show which class you check , kind of work logsuggestion4: also step into sub-packages e.g. not just rcc but also rcc.unittests. codeinspector could be a good startsugesstion5: allow also MAC, INT, INC code to be checked
go to post Robert Cemper · Sep 23, 2024 it would be great if the issues in building Docker container would be fixed.so we can touch it and reduce frustration of evaluators firstActually it is broken, Issues pending since some days
go to post Robert Cemper · Sep 23, 2024 is there anywhere a working example using the template ? or a hint of how to apply it ?
go to post Robert Cemper · Sep 18, 2024 Your code looks like a ClassQuery. %Library.Query This is not a Stored Procedure :=> a ClassMethod ...[SqlProc,SqlName=anyname] and everything happens inside this ClassMethodyou run is by CALL PROCEDURENAME
go to post Robert Cemper · Sep 18, 2024 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 ProcedureI'd suggest to test you queries isolated im SMP or from terminal in SQL shell
go to post Robert Cemper · Sep 18, 2024 UNderstand a STORED PROCEDURE as a special case of a ClassMethodusing CREATE PRODURE .......LANGUAGE OBJECTSCRIPTYou can write it with all specials you needsee docs: https://docs.intersystems.com/iris20242/csp/docbook/Doc.View.cls?KEY=RSQL_createprocedure
go to post Robert Cemper · Sep 13, 2024 if $d(^|"%SYS"|CONFIG("Namespaces"," ")) for set ns=$o(@$ZR) quit:ns="" write ns,! ; or do whatever you intend
go to post Robert Cemper · Sep 12, 2024 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.
go to post Robert Cemper · Sep 11, 2024 ÍD is an reserved name in IRIS / Ensemblein fact as you describe it, it is rather a KEY than a typical IDso this query may serve your needs SELECT LIST(Value) WHERE KEY=11 SELECT LIST(Value) WHERE KEY=12
go to post Robert Cemper · Sep 11, 2024 @Mary George there is one. I just posted a cross namespace cross CLS, MAC; INT, INC searchhttps://community.intersystems.com/post/code-scanner It's pretty fast just using COS and Globals. No class.
go to post Robert Cemper · Sep 4, 2024 Congrats:I like your code example that demonstrates deep understanding of the DB concept. 💪
go to post Robert Cemper · Sep 3, 2024 From docs: tformat = 1 >>> Express time in the form "hh:mm:ss" (24-hour clock).W $ZTIME(338,1,)00:05:38W $ZTIME(338+43200,1)12:05:38My guess: You look for thisW $tr($ZTIME(338,3),"AM")12:05:38