Try:
Class test.Person Extends (%Persistent, %XML.Adaptor) {
Property Id As %Integer [ Calculated, SqlComputeCode = { Set {*}={%%ID}}, SqlComputed ];
Property Name;
}if you don't want to touch the Class you may inherit it from some common Super-Class.
With pure routines, this is an almost impossible attempt.
Since DO doesn't have a differentiator between calling a function or procedure, internal or public or just looping [ do {} while ]
If you do it inside a class you have all this information on functions and procedures in %Dictionary.*
So you can define exactly what you search. And using the code generator you may even do it at compile time.
The most simple way is to redirect your I/O to a TCPport where another job provides you with the expected input:
#1) have a listener: (any port, I use 7777 for the example)
#2) at your report side all you have to do is
here the listener sits on the same machine but it could be any reachable IP-address.
the only critical point is if your program fiddles around changing $IO
it is not possible within the same class as you break the uniqueness of names.
But if you have class A1 with Method MX(....)
you can create class A2 Extends A1 and overload Method MX as you like or need.
You still can call MX of class A1 from class A2 using ##super()
All with the assumption that neither class A1 nor Method MX is FINAL
@Dmitry Maslennikov
Thanks for the excellent example!
The only addon: C/E code has to be separated from IRIS code. (Not really a challenge)
see this article ECP between IRIS and Caché / Ensemble
Did you consider to run that single app on IRIS and connect to your Caché over ECP ?
It works in both directions.
Finally a serious follower to the FeatureMap we have seen last on C/E 2015.2
.png)
https://cedocs.intersystems.com/ens20152/csp/docbook/featuremapCache.csp.png)
SUPER! works excellent! A strong improvement for Docs.
newSpeak [Orwell 1984} : ISOS - accepted 
. or ISCOS ? pls. not IOS !!
Not that I used BASIC more than for a quick 5 line demo. It is still visible in Studio.
.png)
the most remarkable feature: it compiles directly to .obj code without touchable intermediate code (.INT)
@Yuri Marx
Thanks for the quick improvement!
Question:
Is it possible to have some link behind the boxes ?
What I have in mind is a fast directory into Documentation, Subjects in DC, Learning & Training, ...
If all 3 three (or more) have it in common as a starting point,
then search for help and information could become quite easier.
A nice colored table but I miss almost all internal used languages:
COS is hidden as "Obs",
BUT: No BASIC, NO MultiValue, No HTML, No T-SQL / ISQL, no sign of any kind of Networking
Also, Globals as THE core store technology seems to be lost.
You are right.
but if the docs were that clear and resistant to misinterpretation,
this forum would be rather poor.
your question helps others to understand.
keep asking!
The gateway server is mainly taking care of Logging and tracing using 53773 as a backward link.
So your network experts are right.
Exactly!
here is the example Defining a JDBC Connection URL
jdbc:IRIS://<host>:<port>/<namespace>
where the parameters are defined as follows:
AHH! that sounds quite different.
First is your super server port really 53773 ?
Default is 51773. While 53773 might be a gateway port for reverse connection.
you can check in SMP System > Configuration > Memory and Startup
Otherwise
I suspect telnet as a protocol might be blocked by some firewall by principle.
from a terminal prompt in IRIS you might try this:
So you create a TCP listener on port 7000 hanging around
Then try to connect from an external server by telnet to port 7000 on your server
As soon as you send 15 or more characters the READ will complete and you see the content in variable req
As you describe I assume this will fail. Indicating that some firewalls or similar blocks access.
Most likely the port is blocked.
In addition netstat -a from system prompt
or user>$netstat -a from IRIS terminal shows ALL listeners on your system
It's not clear to me what you try:
"..so customers can connect to IRIS remotely using JDBC and not ODBC...."
So they need the related Java-Libraries to connect. see Establishing JDBC Connections
While the setting in your jpg. relate to the SQL-JDBC Gateway that allows access to other DBs over JDBC.
You have also a JAVA gateway to run java out of IRIS See Using the Java Gateway.
An index on reg.mnr and bar.invnum will accelerate this.
That's a general problem of a web interface like this.
You start a query but it isn't finished before your fall into a browser timeout.
An easy workaround:
Start a terminal session (terminals don't know about timeout)
and from prompt run SQl.Shell
.png)
or for a multi-line statement just start with an empty line and run with GO
.png)
It will wait forever until completed
I'm not aware that this is available at SQL / DDL level
You can set the default collation for all globals in a database.
.png)
or specific for an individual global before using it.
.png)
The available collations have to be added here
.png)
https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_INSERTORUPDATE
The article is pretty explicit on the issues of IDkey.
I see 4 critical points to check:
great! That's faster and requires no restart. 
what you are looking for is called global indirection
and so on
As these buffers are a (hopefully large) pool that belongs to your whole installation.
They are only cleared if you restart Caché.
But you should probably take a look at your "disk drives" (whatever type they are).
Their performance might be worth to check
[in quotes as they might be virtual in some way]
In addition, a performance check with WRC might make sense.
They are top experts to the subject.
If you have a large buffer pool you might run a $QUERY() loop across the whole global
in the morning and hope it stays there long enough. Some installations practice it that way.
Almost right!
not $order but the related global blocks are cached in global buffers.
large global buffers improve performance but they have to be loaded first.
and disk access is the slowest part in your machine (except network)
so at 1st access, you load the buffers and that might be slow.
any further access uses the loaded buffers
@Evgeny Shvarov GREAT ! I had never expected this practical value!
Thank you @Dan Pasco !
This confirms that it is not just a crazy idea ( as some of my former colleagues classified it).
I met this during testing about a decade ago to manage test data and to compare the impact of code changes.
And - based on my history - the global was and is the ultimate truth for me of what is done on objects.
Robert
Thanks @Evgeny Shvarov for checking !
the clause item IN ('$ZE','$ZV') catches the same set of records twice.
image + fix in the original reply