All
Accepted answers
Dmitry Maslennikov · Mar 5, 2024 go to post

with IKO, tls for wegateway does not work at all, only loginSecret works

I expected that just define webgateway even without tls, will work, but still no

Dmitry Maslennikov · Feb 23, 2024 go to post

So, you still store JSON as a text, and not some binary form, then all SQL queries will do JSON parse If I need to extract some property from it, and if I have millions of records, I have to forget about this feature?

Dmitry Maslennikov · Feb 20, 2024 go to post

The best and most correct solution would be to use parameters in SQL and pass a value as a parameter

INSERT INTO MyText
    (text)
VALUES
    (?)

While you have Oracle somewhere behind, Oracle should support parameters as well, but I don't know how it will work in this case

The increase may appear due to passing this query to the next database, and it escaped again. Passing as parameters may solve this issue.

But still even without this apostrophe the string is too long

Dmitry Maslennikov · Feb 16, 2024 go to post

He could find one of the demos, where port 51773 was for a while as a replacement of 1972 when IRIS was very fresh

Dmitry Maslennikov · Feb 5, 2024 go to post

Check the settings, and configure connection to the server, it will not those options if server not available, where to actually import it

Dmitry Maslennikov · Feb 4, 2024 go to post

About quoted properties, from my experience, the only scenario where those properties can be used is with JSON, but it's not necessary there anyway and can be declared differently.

Dmitry Maslennikov · Jan 22, 2024 go to post

What do you mean, what version?

Need to see the list of SQL Tables, use this query

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE';
Dmitry Maslennikov · Jan 9, 2024 go to post

There were multiple ways to build applications back then

  • Using globals to store data, no this way can be called NoSQL, this case will require additional work on the server side
  • and using persistent classes, which can be accessed via SQL

So, depends on how old this application is, and it has not updated for a long time

If you already know for certain, that the data you need can be accessed through SQL, then it's possible to make Flink working

Dmitry Maslennikov · Jan 8, 2024 go to post

There are no such tools at the moment, or anything similar to Oracle GoldenGate.

I suppose you meant Apache Flink, https://github.com/ververica/flink-cdc-connectors

Yeah, there is no support for Caché/IRIS. But it can be implemented, I already have experience with it

But, such an old system may not have adoption to SQL, and would require some additional work on the Caché side.

You may try using JDBC connection, to check if the data available through SQL. Then it could worth to implement flink CDC connector for Caché/IRIS.

Just in case you can use other options, I've already adapted Trino and Presto

Dmitry Maslennikov · Dec 20, 2023 go to post

Deprecation of this feature, quite a big deal, actually.

One of the use cases, I would think is mostly used here, is to shorten package names in SQL. So instead of using a multi-level package long name, use shortened form, which is quite handy.

Dmitry Maslennikov · Dec 20, 2023 go to post

That's quite a strange task, what exactly do you need to achieve?

I have no idea what the format is there.

Dmitry Maslennikov · Dec 20, 2023 go to post

Yeah, I do answer sometimes, did not expect, that's so much, and I did not expect that I was tagged so much too

Dmitry Maslennikov · Dec 19, 2023 go to post

The issue is, that those settings are not presented in UDL formats. Without supporting it as files, and being able to use source control with this, it won't be easy to use.

Dmitry Maslennikov · Dec 18, 2023 go to post

There is a function `exec`, which may help to execute something after start, and has option to update the command using `with_command`

Dmitry Maslennikov · Dec 18, 2023 go to post

Also possible to use Enterprise license

import os
from testcontainers.iris import IRISContainer

license_key = os.path.abspath(os.path.expanduser("~/iris.key"))
image = 'containers.intersystems.com/intersystems/iris:2023.3'
container = IRISContainer(image, username="demo", password="demo", namespace="demo", license_key=license_key)
container.with_exposed_ports(1972, 52773)
container.start()
print('SQLAlchemy URL', container.get_connection_url())
print('Username', container.username)
print('Password', container.password)
Dmitry Maslennikov · Dec 13, 2023 go to post

Of course, and if you read my article, you will find a paragraph and code with it. And I'm saying that it's only available as ObjectScript representation, but not in Embedded Python, and there is no backward function, no way to get $listbuild out of pythons list

Dmitry Maslennikov · Dec 11, 2023 go to post

$Horolog itself does not contain information about timezone, it's just date and time

if you need to make it to another timezone, you can just add or subtract difference

Dmitry Maslennikov · Dec 4, 2023 go to post

Yes, if you send too much, and the listener will not be able to read such fast, it may cause overflow, and the whole server may stop working. You can use Count(resourceName)

Dmitry Maslennikov · Dec 4, 2023 go to post

%SYSTEM.Event is only for Inter-Process communication and messages sent through SharedMemory, which may cause some issues if not used correctly (overflow for instance).

The only way to send it to Global, is to make the listener which will do it, but using %system.Event in this case makes no sense, if you could do it without it.

Dmitry Maslennikov · Nov 26, 2023 go to post

Making SDK is the easiest part, tracing abilities are what's missing in the Language, I mean tracing which could be used in realtime, with no significant performance degradation.

Dmitry Maslennikov · Nov 24, 2023 go to post

There is no way to support tracing for ObjectScript, this is the feature I would like to implement, and have some ideas, but it's quite a tricky task

Dmitry Maslennikov · Nov 24, 2023 go to post

You already found port 52773

IRIS does not have http://localhost:52773/RPCNAME, 

Where did you get it RPCNAME? How did you configure it in IRIS? What else would you expect it to answer?

I tried to find anything about VistA RPC Broker, and found only an installation guide from 1997, It's a year when Caché was released. 

So, you are asking about VistA RPC Broker on IRIS, I don't know how it's possible 

And why it's an issue with IRIS, not with VistA RPC Broker