You can try this to create XLSX files from SQL queries (in the same project there's also XLS exporter).

Another option would be to export CSV and use LibreOffice to convert it to XLSX (among other formats). Here's how.

First of all, I'd really like to recommend you to upgrade to InterSystems IRIS.

You can still set query timeout as a part of JDBC connection string if it is available in external DBMS implementations.

Call it?

First argument is the statement index and the second is how long to wait in seconds.

I would recommend setting this parameter as a part of JDBC connection string if applicable - it is available in some DBMS implementations.

Would be a great language to add.

Are you interested in calling Rust code from InterSystems IRIS or interfacing with InterSystems IRS from Rust?

Currently you can use Callin/Callout functionality for C/C++ and calll that from Rust.

A while ago I was trying Rust and successfully transpiled C callout library into Rust callout library and compiled it as Rust shared lib and it works (callable from InterSystems IRIS).

For this community project to take off two issues need to be solved:

• Doing something with a lot of generated boilerplate <- Easy part, can probably just dump it into external file as is
• Generating appropriate ZFEntry table. <-Probably possible but I have not researched the issue so far

Easiest way to do that is to add a favorite:

set sc = ##class(%SYS.Portal.Users).%AddFavorite("Community","https://community.intersystems.com")

And your portal now looks like this:

Every time you interact with the page your session is extended for session timeout.

If there's no interaction from user after session timeout the session dies and cookie becomes invalid.

You can adjust session timeout parameter in web application settings.

VisitTime  (any property really) should be stored before property parameter change.

Can you try to recreate the data?

Offtopic but generic JDBC provider for SQLAlchemy has been discussed for years in Python community but nothing has been done.

Use class queries. They are colored.

You can use PythonGateway or IRIS Native for Python to do that.

PythonGateway can retrieve dataframe (any object really) as a JSON.

Here's a corresponding discussion on the SQL side of things.

Use Dynamic Gateway for Java. Does not require classes generation at all.

Well, %Collection classes are the implementation of these constructs:

• Property X As List Of Type
• Relationships

You can call their methods but do not explicitly create objects of these classes.

%Collection classes are internal and not to be used.

You can request new features/enhancements in WRC tickets.

There is actually. %GetSerial method builds a $lb from %ListOfDataTypes and %SetSerial does the reverse.

Both of these methods are private though. You can subclass %ListOfDataTypes and publish them.