You can set ..HTMLZIPDoc.Filename to any filepath you need.

You can use %NOCHECK %NOLOCK to speed things up. Work Queue Manager can be used for parallelization.

Try it like this:

new reader,sc,data,xmlSignature

set sc=reader.OpenFile(file)
quit:$$$ISERR(sc) sc

set document = reader.Document

do reader.Correlate("Signature","%XML.Security.Signature")
if 'reader.Next(.xmlSignature,.sc) {
    quit sc
}

quit xmlSignature.ValidateDocument(document)

From docs.

Note that it requires that you're the only writer on the system during that update.

There are two options:

1. Use SQL Gateway to create Linked Tabled from Oracle (if there are a lot of tables it might be better to create a linkage with a view). After that query Linked Table same as any normal InterSystems IRIS table using the code snippet above.
2. Write a service with the EnsLib.SQL.InboundAdapter to query Oracle database. In that case you need to implement a CSV writer.

Use three repos: dbLib, dbA, dbB.

Add dbLib as submodule to both dbA and dbB.

Calculating detailed class/table size.

Check Retain cached query source option?

Only if the property becomes calculated after being stored which I don't see happening that often.

Sure

Property D As %String [ Calculated, SqlComputeCode = {set {*}=##class(CClass).DGetStored(##class(BClass).CGetStored(##class(ClassA).BGetStored({A})))}, SqlComputed ];

Would be way faster than SQL approach too.

if you need to get a->b->c->d 

That's what chained GetStored is for!

and they at the same time can be null

GetStored is a safe method: GetStored("") -> "", so it can be safely used even if some values are NULL.

Starting with 2020.1 Universal Query Cache is used for all SQL statements.

Have you encountered an issue with it?

Pinging @Benjamin De Boe

Use %VarString instead of %String. It has 3.6Mb limit by default.

You do it by chaining GetStored methods:

Class Document Extends %Persistent {

Property Filename As %VarString;

}

Class Question As %Persistent {

// Or relationship
Property Document As Document;

Property Filename As %String [ Calculated, SqlComputeCode = {set {*}=##class(Document).FilenameGetStored({Document})}, SqlComputed ];

}

DeepSeeWeb review seems to be missing.

I'm not really sure what is it that you want (please consider providing more information), but this project can be used to both read and write excel files.