Sorry,
I had in mind to set SQLCODE = -400 , %msg, . .. or similar Embedded SQL variables directly
if it is just for SQLCODE instead of ProcedureBlock = 0 you may use
ClassMethod Get(pId As %String) As %String [ SqlName = GetMsg, SqlProc , PublicList = SQLCODE ]
% variables are public anyhow
details on PublicList
Did you try to use
ClassMethod Get(pId As %String) As %String [ SqlName = GetMsg, SqlProc , ProcedureBlock = 0 ]
to get SQLCODE and related variables out fo your Class Context ?
Sorry, I had no chance to try it self.
I think it's both
#1 missing a lot of important countries
#2 wrong (or very aged) since FRANCE: 20 would mean to have 1 employee by customer . This simply can't match.
I think a look at the WRC registry might give some feeling on the dimensions. (without disclosing details)
For my case 5 yrs back picking out 1 of my partners which had >30 installations at 30 companies.
Could be they count "Intersystems Only" - but that's not stated nor does it make sense.
walking through their web pages you see fast who is their preferred product supplier. no need to mention
Attention!
The list of companies from enlyft.com is totally wrong.
Even if you just look at Electronic Health Record you miss important countries like whole Scandinavia, Italy, Germany, China, ...
and beyond that whole middle and eastern Europe and especially Russia. Where is Japan ?
Just as a signal how massively wrong these figures are:
My small Austria has more companies using Intersystems products than this 26 counting for India.
I'd suggest you contact Intesystems Marketing for REAL figures.
Your source is just faked information.
Thanks for the confirmation.
By this trick, (applied on coordinates) I could beat Oracle Spacial by magnitudes
Thanks for the feedback!
& Happy New Year
the issue is here:
Method RtnReceive(RtnName As %String,
RtnLines As %ListOfDataTypes(ELEMENTTYPE="%String",
XMLITEMNAME="RtnLinesItem",XMLNAME="RtnLines")) As %String [ Final, ProcedureBlock = 1, SoapBindingStyle = document, SoapBodyUse = literal, WebMethod ]
{use instead ELEMENTTYPE="%VarString",
%VarString inherits from %String all except pre-define MAXLEN=50
Wild guess from the hip:
Your Data Type is a %String with default (MALXLEN=50)
Try instead %VarString or %XML.String
A few recommendations to improve performance:
#1) %TimeStamp is a nice thing for display tough rather inefficient for indexing as it is mostly close to a unique index.
If you just check for Date as you describe you better use an index on a calculate property of type %Date
instead of a string, your date values in index are just integers !!!
that makes your index slim and fast.
#2)
check for = is the easiest one, therefore, the fastest
check for > is the slowest as you have no stop condition
between is somewhat better as you have to check > and < but you have a start / stop delimited range.
And integer compare is by dimensions faster than any string compares with any available processor chip.
And you do lots of them!
in reality, better check the number of Global references and lines you execute.
That's the truth. Costs are good guesswork based on generic parameters out of tune table but rather for the dimension.
SUPER !
less scrolling = easier to foloww the contents.
A real Xmas gift! 
Congrats & best wishes
@Kenneth.Poindexter8571 this is correct
though the result might be disappointing.
See: >ping www.intersystems.com
Antwort von 172.227.166.122: Bytes=32 Zeit=22ms TTL=55
But:
USER>w $system.INetInfo.AddrToHostName($C(172,227,166,122))
a172-227-166-122.deploy.static.akamaitechnologies.com
USER>
here ist lengthy doc to the wizard
https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GSTD_Start#GSTD_CreateWeb
map your MS SQL Table to a class using SQL gateway
in Studio create a new CSP page
<html>
<head> <!-- Put your page Title here -->
<title> Cache Server Page </title> </head> <body>
<!-- Put your page code here -->
My page body
</body>
</html>
use Tool / Templates / WebForm Assistant
select your Class and the Properties you need
compile it
use it
.png)
Great to see the subject coming up.
Especially as I had a very personal relationship to it starting with version -2 (SpeedMiner??)
or so before it was named DeepSee 1.
Sorry. My DOCKER is a Windows version. Iris is Ubuntu.
So it is UBUNTU inside Windows.
CACHE & IRIS have JDBC drivers as part of the installation.
see this:
https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=BGJD_preface
an example for SQLdeveloper using 3rd party JDBC (here DB2) might be a guideline how to proceed
https://www.db2tutorial.com/getting-started/sql-developer-db2/
just tried your line:
My docker is slightly older.
Checked it on Ubuntu server
rcemper@TEST:~$ sudo bash
[sudo] password for rcemper:
root@TEST:~#
root@TEST:~# docker --version
#Docker version 19.03.4, build 9013bf583a
And this one runs on WIN10
>docker --version
Docker version 19.03.4, build 9013bf5
Same result for both of them:
>docker container run -it -p 51773:51773 -p 52773:52773 -p 5001:5001 -p 5000:5000 --name rcc2 --rm store/intersystems/iris-community:2019.3.0.309.0
[WARNING] No init process detected! This container may accumulate zombie processes if run for a long time. Consider using "docker create --init ..." or equivalent.
[INFO] Starting InterSystems IRIS instance IRIS...
[INFO] This copy of InterSystems IRIS has been licensed for use exclusively by:
InterSystems IRIS Community
Copyright (c) 1986-2019 by InterSystems Corporation
Any other use is a violation of your license agreement
Starting IRIS
12/01/19-22:24:43:883 (397) 0 [Generic.Event] Automatically configuring buffers
12/01/19-22:24:43:959 (397) 0 [Generic.Event] Allocated 421MB shared memory: 249MB global buffers, 35MB routine buffers
12/01/19-22:24:43:961 (397) 0 [Crypto.IntelSandyBridgeAESNI] Intel Sandy Bridge AES-NI instructions detected.
12/01/19-22:24:43:975 (397) 0 [WriteDaemon.UsingWIJFile] Using WIJ file: /usr/irissys/mgr/IRIS.WIJ
12/01/19-22:24:43:976 (397) 0 [WriteDaemon.CreatingNewWIJ] Creating a new WIJ file
12/01/19-22:24:45:445 (397) 0 [WriteDaemon.CreatedNewWIJ] New WIJ file created
- - - -
Hi
We used this @ german symposium:
>docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
store/intersystems/iris-community 2019.3.0.309.0 ccc1f07e75b6 2 months ago 1.33GB
>docker run -it -p 51773:51773 -p 52773:52773 -p 5001:5001 -p 5000:5000 -v c:\DockerData\:/data --name rcc2 --rm ccc1f07e75b6
[WARNING] No init process detected! This container may accumulate zombie processes if run for a long time. Consider using "docker create --init ..." or equivalent.
[INFO] Starting InterSystems IRIS instance IRIS...
[INFO] This copy of InterSystems IRIS has been licensed for use exclusively by:
InterSystems IRIS Community
Copyright (c) 1986-2019 by InterSystems Corporation
Any other use is a violation of your license agreement
Starting IRIS
12/01/19-19:13:57:734 (397) 0 [Generic.Event] Automatically configuring buffers
12/01/19-19:13:57:808 (397) 0 [Generic.Event] Allocated 421MB shared memory: 249MB global buffers, 35MB routine buffers
12/01/19-19:13:57:810 (397) 0 [Crypto.IntelSandyBridgeAESNI] Intel Sandy Bridge AES-NI instructions detected.
12/01/19-19:13:57:825 (397) 0 [WriteDaemon.UsingWIJFile] Using WIJ file: /usr/irissys/mgr/IRIS.WIJ
12/01/19-19:13:57:825 (397) 0 [WriteDaemon.CreatingNewWIJ] Creating a new WIJ file
12/01/19-19:13:58:490 (397) 0 [WriteDaemon.CreatedNewWIJ] New WIJ file created
12/01/19-19:13:58:493 (397) 0 [Generic.Event]
Startup of InterSystems IRIS [IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2019.3 (Build 309U) Wed Sep 11 2019 16:20:03 EDT]
in /usr/irissys/bin/
with mgr: /usr/irissys/mgr
with wij: /usr/irissys/mgr/IRIS.WIJ
from: /usr/irissys/mgr/
OS=[Linux], version=[#1 SMP Tue Jul 2 22:58:16 UTC 2019], release=[4.9.184-linuxkit], machine=[x86_64]
nodename=[e3f43e3bfd15].
numasyncwijbuf: 0, swdwrtmax: 0, wijdirectio: off, synctype: 3
System Initialized.
12/01/19-19:13:58:504 (398) 0 [WriteDaemon.Started] Write daemon started.
12/01/19-19:13:59:795 (409) 0 [Database.MountedRW] Mounted database /usr/irissys/mgr/ (SFN
and it works as expected .
But I used no durable feature !!
Thanks for the clarification.
It's a rare chance I might be up at that early time 
and if my body is it doesn't mean my brain is too.
the code worked together with the link: ObjectScript Leaderboard
@Dmitry Maslennikov I joined your leaderboard
This is the private leaderboard of Dmitry Maslennikov for Advent of Code 2019.
It seems to be the official one (at least by the well-known names).
is the code the same as last year ???
130669-ab1f69bf
???
Could someone explain to a newcomer what the time is telling me ?
Any local time (lokes like EST) ? or some total ???
--------Part 1-------- --------Part 2-------- Day Time Rank Score Time Rank Score 1 11:37:18 15816 0 11:50:08 14212 0
what is the join code for ObjectScript Leaderboard
I get asked for ??
You can join a private leaderboard by entering its join code here:
You don't have a private leaderboard. You can only have one. You can [Create It] now.
mine is Windows.
I just tried it with the Symposium (Docker, UBUNTU) ==> Community Version + Key
| License Capacity | InterSystems IRIS Community license |
| Customer Name | InterSystems IRIS Community |
| Order Number | 54702 |
| Expiration Date | 10/30/2021 |
| Authorization Key |
8116600000500000500008000084345EF8F2473A5F13003 . . . . . . |
Atelier required a restart but then it worked.
WELL: default in Ubuntu / Docker : firewall off
I fear Red Hat is different. But my last Red Hat is 15 yrs back :-(
My personal decision was to move to Docker because it is really easy after 1/2 day playing with basics.
Hi Udo,
I tried it with my 1 year old Atelier installation.
Setup of a new sever connection.
The test showed me:
.png)
OK so I changed to PASSWORD only
.png)
AND the test worked OK. And access as well..
you either remove the reference to the object
or terminate the process that holds the references.
The added %XML.Adaptor is not active until the related object is closed and a new instance of it is opened again.
check license usage in SMP/Operations
Check CSP Session as well
In Security / Application force authentication not to lose licenses to Unknown user,
It is not to comfortable but may help.
BTW. my preview licenses had all features but NO users. I kicked them as useless.
You are on the right way.
It has to be a SYSTEM DSN.
in win10 clich to start
then click the GEAR symbol
next search for ODBC and you should be there.
OR
search from WINDOWS control panel -> administration -> ODBC data sources (64bit) -> System DSN
sorry. this was done by a PHP developer back in 2008/2009.
the <Caché side was default from the wizard.
I have no idea about the details anymore.