Routine names starting with %Z or %z go to namespace %SYS automatically:
Though by mapping it to namespace %ALL any routine can be available in any namespace
- Log in to post comments
Routine names starting with %Z or %z go to namespace %SYS automatically:
Though by mapping it to namespace %ALL any routine can be available in any namespace
Hi al!,
Just returning from some private troubleshooting I'm deeply moved and thankful for this feedback.
It's once more a motivation to continue my activities.
Sometimes I'm insisting on small pieces that may bypass general attention.
Though servicing customers - and I understand you all as my customers -
requires to take care also of the small and often annoying pieces.
Special big THANKS to the brilliant team behind the DC+OEX+GM facility.
YOU ARE GREAT. 💐🌷🌺🌸💮🌼🌻
Thank you for publishing my attempts and the clear message:
Symbols used in ObjectScript may fit your needs
messages.log is in %instslldir%\mgr\ as ususal
Special thanks for Step 4 - Docker
this allows you to train the technical presentation over and over in the same way
Nothing is more disturbing than a presenter who seems to see the code first time 😎
you are in Caché so this might help:
http://localhost:57772/csp/docbook/DocBook.UI.Page.cls?KEY=GIOD_rmsseqf…
USE file:position
the equivalent in %Stream,Object is MoveTo
• method MoveTo(position As %Integer) as %Boolean
Move to this position in the stream. If this suceeds then return true, else return false. Note this implementation is not efficient because it searches from the start of the stream, it can be improved upon in specific subclasses. Note that moving to position 1 will be at the start of the stream, position 2 will be at the second character of the stream, etc.
And then you do your Read or Find..
Hi @Luis Angel Pérez Ramos
I got in fact the same values with my iris community edition.
Test Columnar vs. Row Storage
=============================
1 - Initialize Tables
2 - Generate Data
3 - Compare SELECT
4 - Loop SELECT
5 - Auto Loop
Select Function or * to exit : 5 Loops to run :25
Set steps by loop
Records to add (1...10000)[1]:10000
records = 15000 row = .033238 col = .044981
records = 25000 row = .007728 col = .000254
records = 35000 row = .011427 col = .000335
records = 45000 row = .014625 col = .000406
records = 55000 row = .018682 col = .000500
records = 65000 row = .023468 col = .000562
records = 75000 row = .026235 col = .000659
records = 85000 row = .029151 col = .000738
records = 95000 row = .032212 col = .000794
records = 105000 row = .035926 col = .000856
records = 115000 row = .039431 col = .000934
records = 125000 row = .043036 col = .001008
records = 135000 row = .049134 col = .001074
records = 145000 row = .050405 col = .001404
records = 155000 row = .054313 col = .001669
records = 165000 row = .058039 col = .001380
records = 175000 row = .060756 col = .001384
records = 185000 row = .064746 col = .001451
records = 195000 row = .068403 col = .001665
records = 205000 row = .070737 col = .001642
records = 215000 row = .073610 col = .001690
records = 225000 row = .078551 col = .001797
records = 235000 row = .084139 col = .001997
records = 245000 row = .087316 col = .001908
records = 255000 row = .087862 col = .002546
records = 265000 row = .090478 col = .002152You might appreciate this approach
https://community.intersystems.com/post/columnar-vs-row-storage-iris-native
and BTW. thanks for the inspiration.
Just in case i misunderstood you.:
So: what are you looking for ?
And BTW. Its concept ia available for 4+ decades.
It just had no Object, no SQL, no fancy name then,
My Review - before being approved by OEX admins
I just have upgraded this very nice tutorial into IPM and Docker
OEX: https://openexchange.intersystems.com/package/WebSockets-TutorialDemo +
Demo + PR to be merged sometime https://github.com/rcemper/DK_Tutorial-WebSockets
select CurrentDevice from SYS.Process group by CurrentDevice| CurrentDevice |
|---|
| //./NUL |
| |TCP|1972 |
| |TCP|1972|7868 |
| |TCP|1972|7104 |
| |TCP|1972|19332 |
| |TCP|1972|9316 |
| |TCP|1972|12932 |
| |TCP|1972|17224 |
| |TCP|1972|8096 |
10 row(s) affected
select Pid,CurrentDevice,ClientNodeName,ClientIPAddress from SYS.Process
USER>w $ZV
Cache for Windows (x86-64) 2018.1.7
What OS are you working on? Win, Mac, Linux, ``
Just half a screen down
Restore Selected or Renamed Databases Using ^DBREST.png)
should be no need to fiddle inside DBREST
¿ was the docu not sufficient: Restore All Databases Using ^DBREST ?
Once upon a time ...
So on drive DUA1 you refer to director TEST3
Therefore it's good practice to start with
Kill ^SPOOL($J) Open 2:$J Use 2 .....
as we did in 1978
welcome to my world
what's your expectation?
What would you like to trace?
pls. be more specific
default super Server port = 1972 !
set int = +testingID
my private hack for this situation:
ClassMethod MyMethodPost() As %Status
{
$$$LOGINFO("JobId: "_$JOB)
kill ^%kurro
set ^%kurro(0)=$JOB
for {hang 20 break quit:$get(^%kurro) }
#; just hang around until ^%kurro =1
.....
Quit $$$OK
}underscore is not allowed in names and variables
underscore is the string concatenation operator
the ultimate hack for far outside docker IP:
https://community.intersystems.com/post/how-get-docker-host-ip#comment-218456
for easy reading, not a oneliner yet.
new $namespace,host,ipaddr,p
znspace "%SYS"
set host=$system.INetInfo.LocalHostName()
set ipaddr=$system.INetInfo.HostNameToAddr(host)
do ##class(Config.Startup).Get(.p)
set url="http://"_ipaddr_":"_p("WebServerPort")_"/csp/sys/UtilHome.csp"
kill p,host,ipaddr
quit
zw url
just tested it. works excellent !
You can map PACKAGE [aka. SQL Schema] to another Namespasce (not a single table)
e.g. Bna.Utils to namespace %ALL or just to a specific namespace
so you have Table and Class (= the code) available.
.png)
If you want to share also DATA you need to map also the related Global