User comments | InterSystems Developer Community

See

If you run the following code, then the type of variables a and b in the generated class will be %Stream.GlobalCharacter

create table dc.test
(
a LONGVARCHAR,
b CLOB
)

In addition, I'm no expert in JDBC but wit seems that LONGVARCHAR has a Maximum Length 32,700 characters in JDBC, not quite enough for an arbitrary stream.

Max Size for LONGVAR(BINARY/CHAR) = 2147483647, for VAR(BINARY/CHAR) = 4096

PS: By the way, in DbVisualizer you can view all types supported by the InterSystems IRIS JDBC driver, their numeric codes, maximum sizes, and much more.

Vitaliy Serdtsev · Feb 16 go to post

See URLMap with <Map> Elements

Vitaliy Serdtsev · Feb 12 go to post

Same thing, just different:

set true="1",
    false=0,
    j={}do j.%Set("a",1,"boolean")
do j.%Set("b",0,"boolean")
set j.c=true
set j.d=false
  
set iter = j.%GetIterator()
while iter.%GetNext(.key, .value, .type ) {
  write "key = "_key_", value = "_value_", type = "_type,!
}

Output:
key = a, value = 1, type = boolean
key = b, value = 0, type = boolean
key = c, value = 1, type = string
key = d, value = 0, type = number

Vitaliy Serdtsev · Feb 11 go to post

Actually, my another proposal is to have true and false as part of the language, where true=1 and false 0 or similar for booleans.

Isn't that the case now?

set true="1",
    false=0,
    j={"a":true,"b":false,"c":(true),"d":(false)}
</FONT><FONT COLOR="#0000ff">set </FONT><FONT COLOR="#808000">iter </FONT><FONT COLOR="#000000">= </FONT><FONT COLOR="#808000">j</FONT><FONT COLOR="#000000">.</FONT><FONT COLOR="#0000ff">%GetIterator</FONT><FONT COLOR="#000000">()
</FONT><FONT COLOR="#0000ff">while </FONT><FONT COLOR="#808000">iter</FONT><FONT COLOR="#000000">.</FONT><FONT COLOR="#0000ff">%GetNext</FONT><FONT COLOR="#000000">(.</FONT><FONT COLOR="#808000">key</FONT><FONT COLOR="#000000">, .</FONT><FONT COLOR="#808000">value</FONT><FONT COLOR="#000000">, .</FONT><FONT COLOR="#808000">type </FONT><FONT COLOR="#000000">) </FONT><FONT COLOR="#800080">{
  </FONT><FONT COLOR="#0000ff">write </FONT><FONT COLOR="#008000">"key = "</FONT><FONT COLOR="#000000"></FONT><FONT COLOR="#808000">key</FONT><FONT COLOR="#000000"></FONT><FONT COLOR="#008000">", value = "</FONT><FONT COLOR="#000000"></FONT><FONT COLOR="#808000">value</FONT><FONT COLOR="#000000"></FONT><FONT COLOR="#008000">", type = "</FONT><FONT COLOR="#000000">_</FONT><FONT COLOR="#808000">type</FONT><FONT COLOR="#000000">,!
</FONT><FONT COLOR="#800080">}</FONT>
Output:
key = a, value = 1, type = boolean
key = b, value = 0, type = boolean
key = c, value = 1, type = string
key = d, value = 0, type = number

Vitaliy Serdtsev · Jan 21 go to post

@Evgeny Shvarov

Unfortunately, I have not yet found a documented and [Not Internal] way out of the box to see not only the text of the request, but also the values of its input parameters.

PS: take a look at the methods of the %SYSTEM.SQL.xDBC class. Here is an example of the log for the query above (from DbVisualizer):

SQL text (raw from client): 1 lines
line 1: SELECT * FROM del . a WHERE id < :%qpar(1)
Var Types: Parameter 1: Constant of type INTEGER
INPUT params:
%qpar(1) = 3

Vitaliy Serdtsev · Jan 21 go to post

If auditing is enabled, you can see the query without the actual parameter values. To copy the query to the SQL query tool, the query will also have to be cleaned of garbage.

For example, there is the following query

<FONT COLOR="#0000ff">select </FONT><FONT COLOR="#000080">* from </FONT><FONT COLOR="#008000">del.a </FONT><FONT COLOR="#000080">where </FONT><FONT COLOR="#008000">id</FONT><FONT COLOR="#000000"><3</FONT>

From SMP:

Event: DynamicStatementQuery
Event Data: <FONT COLOR="#0000ff">SELECT </FONT><FONT COLOR="#000080"> FROM </FONT><FONT COLOR="#008000">del . a </FONT><FONT COLOR="#000080">WHERE </FONT><FONT COLOR="#008000">id </FONT><FONT COLOR="#000000">< </FONT><FONT COLOR="#000080">?</FONT>

From DbVisualizer:

Event: XDBCStatementQuery
Event Data: <FONT COLOR="#0000ff">SELECT </FONT><FONT COLOR="#000080"> INTO </FONT><FONT COLOR="#800000">:i%%col1</FONT><FONT COLOR="#000000">, </FONT><FONT COLOR="#800000">:i%%col2</FONT><FONT COLOR="#000000">, </FONT><FONT COLOR="#800000">:i%%col3 </FONT><FONT COLOR="#000080">FROM </FONT><FONT COLOR="#008000">del . a </FONT><FONT COLOR="#000080">WHERE </FONT><FONT COLOR="#008000">id </FONT><FONT COLOR="#000000">< </FONT><FONT COLOR="#800000">:%qpar</FONT><FONT COLOR="#000000">(1)</FONT>

Vitaliy Serdtsev · Jan 21 go to post

Since you used the migration wizard, I assume that the problem is due to the primary key ID and the indexes on it.

Can you use the wizard to create a test table with only two fields, ID and row_status, and post the source code of the generated class here? And more: how many records are there in the table?

Vitaliy Serdtsev · Jan 21 go to post

Enable auditing for %System/%SQL/DynamicStatementQuery, %System/%SQL/EmbeddedStatementQuery, %System/%SQL/XDBCStatementQuery system events.

You can view last actual values of the passed parameters of SQL query in SMP: System > Processes > Process Details > Variables

Vitaliy Serdtsev · Jan 16 go to post

Rather, the discussion was about out-of-the-box equivalents of some SQL functions, so that programmers wouldn't have to reinvent the wheel. Furthermore, the routine of ^%qarfunc is undocumented.

For example, making an Object Script analog of VECTOR_COSINE for integer vectors yourself is a non-trivial task, given that $VECTOROP doesn't support the integer type.

Sometimes it's easier to use embedded SQL.

Vitaliy Serdtsev · Jan 15 go to post

I'm curious why LPAD, RPAD and similar string functions are not exposed as $SYSTEM.SQL.Functions class members

This is a good question that I would also like to get an answer to.

Vitaliy Serdtsev · Jan 15 go to post

LPAD is a SQL function, not an ObjectScript function, which is why it didn't work for you if you replaced the single quotes with double quotes.

USER>write ">"_LPAD(1,10,"0")_"<"
><
USER>write ">"_$$lpad^%qarfunc(1,10,"0")_"<"
>0000000001<

There are two ways to solve the problem: using embedded SQL or an analog of LPAD for ObjectScript, for example:

CREATE TABLE example_table (
    id VARCHAR(10) PRIMARY KEY,
    normalized_id VARCHAR(10) COMPUTECODE {
        &sql(select LPAD(:{id}, 10, '0') into :{*})
    }
    COMPUTEONCHANGE(id))

Vitaliy Serdtsev · Jan 13 go to post

See Signing XML Documents (and especially pay attention to section "Requirements of the XML-Enabled Class")

Vitaliy Serdtsev · Jan 12 go to post

This should be checked on your environment, depending on the versions of Caché, Windows, and Microsoft SQL Server used. I have already provided the code for this above.

I would advise you to first make sure that you are using the latest version of Caché (and the ODBC/JDBC driver), which has fixed many bugs, including various memory leaks: Caché® and Ensemble® Change Notes (2018.1.11)

In addition, you may find the New Method $SYSTEM.Util.CleanDeadJobs() useful.

Vitaliy Serdtsev · Jan 9 go to post

Judging by the source code of the method EnsLib.SQL.Snapshot:ImportFromResultSet (I checked on 2025.3 CE) support for VARBINARY and LONGVARBINARY types is present.

Vitaliy Serdtsev · Jan 9 go to post

Once upon a time, ~~when the grass was greener and the sky was bluer~~, there was even an add-in application Caché RoseLink^PDF.

Vitaliy Serdtsev · Jan 9 go to post

Here is what is in the documentation for Caché:

Disable Query Timeout — Optional. If selected, causes the ODBC client driver to ignore the value of the ODBC query timeout setting.
The ODBC query timeout setting specifies how long a client should wait for a specific operation to finish. If an operation does not finish within the specified time, it is automatically cancelled. The ODBC API provides functions to set this timeout value programmatically. Some ODBC applications, however, hard-code this value. If you are using an ODBC application that does not allow you to set the timeout value and the timeout value is too small, you can use the Disable Query Timeout option to disable timeouts.
java.sql Exceptions The following exceptions are listed here for completeness, but are not required and are never used: ... SQLTimeoutException ...

You can empirically verify all your considerations by calling a custom stored procedure from Microsoft SQL Server, for example:

Class dc.a [ Abstract ]
{
</FONT><FONT COLOR="#000080">Query </FONT><FONT COLOR="#000000">DbgSqlProc(
  </FONT><FONT COLOR="#ff00ff">qMaxRows </FONT><FONT COLOR="#000000">= </FONT><FONT COLOR="#000080">10</FONT><FONT COLOR="#000000">,
  </FONT><FONT COLOR="#ff00ff">qTimeWait </FONT><FONT COLOR="#000080">As %SmallInt </FONT><FONT COLOR="#000000">= </FONT><FONT COLOR="#000080">3</FONT><FONT COLOR="#000000">) </FONT><FONT COLOR="#000080">As %Query</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#000080">ROWSPEC </FONT><FONT COLOR="#000000">= </FONT><FONT COLOR="#800080">"nrow:%Integer,name:%String"</FONT><FONT COLOR="#000000">) [ </FONT><FONT COLOR="#000080">SqlProc </FONT><FONT COLOR="#000000">]
{
}
</FONT><FONT COLOR="#000080">ClassMethod </FONT><FONT COLOR="#000000">DbgSqlProcExecute(
  </FONT><FONT COLOR="#000080">ByRef </FONT><FONT COLOR="#ff00ff">qHandle </FONT><FONT COLOR="#000080">As %Binary</FONT><FONT COLOR="#000000">,
  </FONT><FONT COLOR="#ff00ff">qMaxRows </FONT><FONT COLOR="#000000">= </FONT><FONT COLOR="#000080">10</FONT><FONT COLOR="#000000">,
  </FONT><FONT COLOR="#ff00ff">qTimeWait </FONT><FONT COLOR="#000080">As %SmallInt </FONT><FONT COLOR="#000000">= </FONT><FONT COLOR="#000080">3</FONT><FONT COLOR="#000000">) </FONT><FONT COLOR="#000080">As %Status
</FONT><FONT COLOR="#000000">{
  </FONT><FONT COLOR="#0000ff">#define </FONT><FONT COLOR="#000000">Log(%s) </FONT><FONT COLOR="#0000ff">Set ^dbgSqlProc(qHandle(</FONT><FONT COLOR="#008000">"id"</FONT><FONT COLOR="#0000ff">),%s)=$ZDateTime($NOW(),1,1,6)
  
  Set </FONT><FONT COLOR="#800000">qHandle</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008000">"id"</FONT><FONT COLOR="#000000">)=</FONT><FONT COLOR="#0000ff">$Increment</FONT><FONT COLOR="#000000">(^dbgSqlProc)
  </FONT><FONT COLOR="#0000ff">Set </FONT><FONT COLOR="#800000">qHandle</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008000">"qMaxRows"</FONT><FONT COLOR="#000000">)=</FONT><FONT COLOR="#800000">qMaxRows
  </FONT><FONT COLOR="#0000ff">Set </FONT><FONT COLOR="#800000">qHandle</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008000">"qTimeWait"</FONT><FONT COLOR="#000000">)=</FONT><FONT COLOR="#800000">qTimeWait
  </FONT><FONT COLOR="#0000ff">$$$Log</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008000">"1_Execute"</FONT><FONT COLOR="#000000">)
  </FONT><FONT COLOR="#0000ff">For </FONT><FONT COLOR="#800000">i</FONT><FONT COLOR="#000000">=1:1:</FONT><FONT COLOR="#800000">qMaxRows </FONT><FONT COLOR="#0000ff">Set </FONT><FONT COLOR="#800000">qHandle</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#800000">i</FONT><FONT COLOR="#000000">)=</FONT><FONT COLOR="#0000ff">$ListBuild</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#800000">i</FONT><FONT COLOR="#000000">,</FONT><FONT COLOR="#008000">"name"</FONT><FONT COLOR="#000000">_</FONT><FONT COLOR="#800000">i</FONT><FONT COLOR="#000000">)
  </FONT><FONT COLOR="#0000ff">Set </FONT><FONT COLOR="#800000">qHandle</FONT><FONT COLOR="#000000">=0
  
  </FONT><FONT COLOR="#008000">; Hang qHandle("qTimeWait")*3
  
  </FONT><FONT COLOR="#0000ff">Quit $$$OK
</FONT><FONT COLOR="#000000">}
</FONT><FONT COLOR="#000080">ClassMethod </FONT><FONT COLOR="#000000">DbgSqlProcFetch(
  </FONT><FONT COLOR="#000080">ByRef </FONT><FONT COLOR="#ff00ff">qHandle </FONT><FONT COLOR="#000080">As %Binary</FONT><FONT COLOR="#000000">,
  </FONT><FONT COLOR="#000080">ByRef </FONT><FONT COLOR="#ff00ff">Row </FONT><FONT COLOR="#000080">As %List</FONT><FONT COLOR="#000000">,
  </FONT><FONT COLOR="#000080">ByRef </FONT><FONT COLOR="#ff00ff">AtEnd </FONT><FONT COLOR="#000080">As %Integer </FONT><FONT COLOR="#000000">= </FONT><FONT COLOR="#000080">0</FONT><FONT COLOR="#000000">) </FONT><FONT COLOR="#000080">As %Status </FONT><FONT COLOR="#000000">[ </FONT><FONT COLOR="#000080">PlaceAfter </FONT><FONT COLOR="#000000">= DbgSqlProcExecute ]
{
  </FONT><FONT COLOR="#0000ff">$$$Log</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008000">"2_Fetch"</FONT><FONT COLOR="#000000">)
  
  </FONT><FONT COLOR="#0000ff">If </FONT><FONT COLOR="#800000">qHandle</FONT><FONT COLOR="#000000">></FONT><FONT COLOR="#800000">qHandle</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008000">"qMaxRows"</FONT><FONT COLOR="#000000">) </FONT><FONT COLOR="#800080">{
    </FONT><FONT COLOR="#0000ff">Set </FONT><FONT COLOR="#800000">Row</FONT><FONT COLOR="#000000">=</FONT><FONT COLOR="#008000">""
    </FONT><FONT COLOR="#0000ff">Set </FONT><FONT COLOR="#800000">AtEnd</FONT><FONT COLOR="#000000">=1
  </FONT><FONT COLOR="#800080">}</FONT><FONT COLOR="#0000ff">else</FONT><FONT COLOR="#800080">{
    </FONT><FONT COLOR="#0000ff">Set </FONT><FONT COLOR="#800000">Row</FONT><FONT COLOR="#000000">=</FONT><FONT COLOR="#800000">qHandle</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#0000ff">$Increment</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#800000">qHandle</FONT><FONT COLOR="#000000">))
    </FONT><FONT COLOR="#0000ff">Hang </FONT><FONT COLOR="#800000">qHandle</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008000">"qTimeWait"</FONT><FONT COLOR="#000000">)
  </FONT><FONT COLOR="#800080">}
  </FONT><FONT COLOR="#0000ff">Quit $$$OK
</FONT><FONT COLOR="#000000">}
</FONT><FONT COLOR="#000080">ClassMethod </FONT><FONT COLOR="#000000">DbgSqlProcClose(</FONT><FONT COLOR="#000080">ByRef </FONT><FONT COLOR="#ff00ff">qHandle </FONT><FONT COLOR="#000080">As %Binary</FONT><FONT COLOR="#000000">) </FONT><FONT COLOR="#000080">As %Status </FONT><FONT COLOR="#000000">[ </FONT><FONT COLOR="#000080">PlaceAfter </FONT><FONT COLOR="#000000">= DbgSqlProcExecute ]
{
  </FONT><FONT COLOR="#0000ff">$$$Log</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008000">"3_Close"</FONT><FONT COLOR="#000000">)
  
  </FONT><FONT COLOR="#0000ff">Quit $$$OK
</FONT><FONT COLOR="#000000">}
}</FONT>

Example of a call: select * from dc.a_DbgSqlProc(11,5)

See Customized Class Queries

Vitaliy Serdtsev · Jan 6 go to post

Well, of course it works. See loads data from 'C:\data\sales.csv' above.

Vitaliy Serdtsev · Jan 6 go to post

Not quite so (see RowID Hidden?).

ALLOWIDENTITYINSERT is needed for other purposes:

Vitaliy Serdtsev · Jan 6 go to post

Set Up Delegated Authentication

Have you enabled delegated authentication for services and applications, in particular for %Service_WebGateway?

Vitaliy Serdtsev · Jan 6 go to post

dc.onetomany.PKG

Class dc.onetomany.products Extends %Persistent
{
Parameter ALLOWIDENTITYINSERT = 1;
Property name As %VarString [ SqlColumnNumber = 2 ];
Property listpriceusd As %BigInt [ SqlColumnNumber = 3 ];
Property description As %VarString [ SqlColumnNumber = 4 ];
}Class dc.onetomany.sales Extends %Persistent
{
Parameter ALLOWIDENTITYINSERT = 1;
Property companyid As %BigInt [ SqlColumnNumber = 2 ];
Property productid As %BigInt [ SqlColumnNumber = 3 ];
Property saledate As %Date [ SqlColumnNumber = 4 ];
Property saleamountusd As %BigInt [ SqlColumnNumber = 5 ];
}Class dc.onetomany.companies Extends %Persistent
{
Parameter ALLOWIDENTITYINSERT = 1;
Property name As %VarString [ SqlColumnNumber = 2 ];
Property industry As %VarString [ SqlColumnNumber = 3 ];
Property description As %VarString [ SqlColumnNumber = 4 ];
Property website As %VarString [ SqlColumnNumber = 5 ];

Query CompaniesBySales() As %SQLQuery(CONTAINID = 1, ROWSPEC = "id:%Integer,name:%String,industry:%String,description:%String,website:%String,totalsales:%Numeric") [ SqlName = CompaniesBySales, SqlProc ]
{
SELECT c.id,
       c.name,
       c.industry,
       c.description,
       c.website,
       SUM(s.saleamountusd) AS totalsales
FROM dc_onetomany.sales s
JOIN dc_onetomany.companies c ON c.id = s.companyid
GROUP BY c.id, c.name, c.industry, c.description, c.website
ORDER BY totalsales DESC
}

Query CompanySalesTotal(companyid As %Integer) As %SQLQuery(CONTAINID = 1, ROWSPEC = "companyid:%Integer,totalsales:%Numeric") [ SqlName = CompanySalesTotal, SqlProc ]
{
SELECT :companyid AS companyid,
       COALESCE(SUM(s.saleamountusd), 0) AS totalsales
FROM dc_onetomany.sales s
WHERE s.companyid = :companyid
}

/// d ##class(dc.onetomany.companies).Test()
ClassMethod Test()
{
  d ##class(dc.onetomany.sales).%KillExtent()
  d ##class(dc.onetomany.companies).%KillExtent()
  d ##class(dc.onetomany.products).%KillExtent()
  
  &sql(LOAD DATA FROM FILE 'C:\data\companies.csv'
  INTO dc_onetomany.companies(id,name,industry,description,website)
  USING {"from":{"file":{"header":true}}})
  
  &sql(LOAD DATA FROM FILE 'C:\data\products.csv'
  INTO dc_onetomany.products(id,name,listPriceUSD,description)
  USING {"from":{"file":{"header":true}}})
  
  &sql(LOAD DATA FROM FILE 'C:\data\sales.csv'
  INTO dc_onetomany.sales(ID,companyId,productId,saleDate,saleAmountUSD)
  VALUES (saleId,companyId,productId,saleDate,saleAmountUSD)
  USING {"from":{"file":{"header":true}}})
  
  s rs = ##class(%ResultSet).%New("dc.onetomany.companies:CompanySalesTotal")
  d rs.Execute(103)
  d rs.Next()
  w rs.Get("totalsales")," <- 17000",!
  s rs = ##class(%ResultSet).%New("dc.onetomany.companies:CompanySalesTotal")
  d rs.Execute(104)
  d rs.Next()
  w rs.Get("totalsales")," <- 7000",!
  
  s c=##class(dc.onetomany.companies).%New()
  s c.name="my name 111"
  d c.%Save()
  w "current ID = ",c.%Id(),!
  
  &sql(insert into dc_onetomany.companies(ID,name) values(500,'my name 500'))
  w "current ID = ",%ROWID,!
  &sql(insert into dc_onetomany.companies(name) values('my name 501'))
  w "current ID = ",%ROWID,!
}

}

USER>d ##class(dc.onetomany.companies).Test()
17000 <- 17000
7000 <- 7000
current ID = 111
current ID = 500
current ID = 501

Vitaliy Serdtsev · Jan 5 go to post

Interestingly, if I try your examples, I can recreate the ambiguity error, but then get an error when attempting to specify the full param specification

What is your version of IRIS and .NET? I have IRIS 2025.3CE and .NET 8.0/Framework 4.6.2 - the examples above work flawlessly and give respectively 1, 0, 1 as indicated in the comments.

This is also possible:

USER>s gw = $System.external.getDotNetGateway()
USER>w gw.invoke("System.Convert","ToBoolean(System.UInt64)",123)
1
USER>

Vitaliy Serdtsev · Jan 5 go to post

Since you manage the ID yourself, in the general case it may not necessarily be a simple counter, but, for example, a Fibonacci sequence. If the source code of the class or table is available, it is better to see how the ID is generated in it. If there is no source code, and you are sure that this is a simple counter, then in my opinion it would be easier to make a standard ID and let IRIS manage it itself.

Vitaliy Serdtsev · Jan 2 go to post

var irisReference = new IRISReference("");
    iris.ClassMethodStatusCode("TestClasses.TestClass", "Method1", irisReference);
    var pReturn = (IRISObject)irisReference.value;
    var list = (IRISObject)pReturn.Get("Entries");
    for (var i = 1; i <= list.InvokeLong("Count"); i++)
    {
        var entry = (IRISObject)list.InvokeObject("GetAt", i);
        Console.WriteLine(entry.GetString("Username"));

    }

Vitaliy Serdtsev · Jan 2 go to post

gateway.new() calls a constructor, but the System.Convert class has no constructors.

To call a static method, use gateway.invoke(), but keep in mind that if you call the following code, an error will occur "Unable to resolve method overloading ambiguity":

write netGate.invoke("System.Convert","ToBoolean",123)

To avoid it, specify the name of the method with the full specification of the parameters, for example:

s gw = $System.external.getDotNetGateway()
w gw.invoke("System.Convert","ToBoolean(int)",123),! ; -> 1
w gw.invoke("System.Convert","ToBoolean(string)","false"),! ; -> 0
w gw.invoke("System.Convert","ToBoolean(string)","true"),! ; -> 1

PS: see Mapping Specification (pay special attention to the sections "Overloaded Methods" and "Restrictions")

Vitaliy Serdtsev · Jan 2 go to post

By the way, what do you think this statement does? Note the %OpenId(20) at the end instead of %New().
#dim a,b,c As Sample.Person = ##class(Sample.Person).%OpenId(20)
Confusing. How about this statement?
#dim a,b,c As Sample.Company = ##class(Sample.Person).%New()
Do you get 3 companies or 3 persons? Does it try to "cast" persons as companies? Do you get an error at compile time or run time? Would it work if Sample.Company extends Sample.Person? More confusion...

There is no confusion.

Here's another example where the class may not even exist and yet the code compiles without errors and according to the documentation.

test.MAC

<FONT COLOR="#0000ff">#dim </FONT><FONT COLOR="#800000">a</FONT><FONT COLOR="#000000">,</FONT><FONT COLOR="#800000">b</FONT><FONT COLOR="#000000">,</FONT><FONT COLOR="#800000">c </FONT><FONT COLOR="#0000ff">As </FONT><FONT COLOR="#008080">%Boolean </FONT><FONT COLOR="#000000">= </FONT><FONT COLOR="#000080">##class</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008080">bla.bla</FONT><FONT COLOR="#000000">).</FONT><FONT COLOR="#0000ff">%OpenId</FONT><FONT COLOR="#000000">(20)
</FONT><FONT COLOR="#0000ff">#dim </FONT><FONT COLOR="#800000">a</FONT><FONT COLOR="#000000">,</FONT><FONT COLOR="#800000">b</FONT><FONT COLOR="#000000">,</FONT><FONT COLOR="#800000">c </FONT><FONT COLOR="#0000ff">As </FONT><FONT COLOR="#008080">bla.bla.bla123 </FONT><FONT COLOR="#000000">= </FONT><FONT COLOR="#000080">##class</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008080">bla.bla</FONT><FONT COLOR="#000000">).</FONT><FONT COLOR="#0000ff">%OpenId</FONT><FONT COLOR="#000000">(20)</FONT>

--> test.INT

<FONT COLOR="#0000ff">Set </FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#800000">a</FONT><FONT COLOR="#000000">,</FONT><FONT COLOR="#800000">b</FONT><FONT COLOR="#000000">,</FONT><FONT COLOR="#800000">c</FONT><FONT COLOR="#000000">)=</FONT><FONT COLOR="#000080">##class</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008080">bla.bla</FONT><FONT COLOR="#000000">).</FONT><FONT COLOR="#0000ff">%OpenId</FONT><FONT COLOR="#000000">(20)
</FONT><FONT COLOR="#0000ff">Set </FONT><FONT COLOR="#800000">a</FONT><FONT COLOR="#000000">=</FONT><FONT COLOR="#000080">##class</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008080">bla.bla</FONT><FONT COLOR="#000000">).</FONT><FONT COLOR="#0000ff">%OpenId</FONT><FONT COLOR="#000000">(20),</FONT><FONT COLOR="#800000">b</FONT><FONT COLOR="#000000">=</FONT><FONT COLOR="#000080">##class</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008080">bla.bla</FONT><FONT COLOR="#000000">).</FONT><FONT COLOR="#0000ff">%OpenId</FONT><FONT COLOR="#000000">(20),</FONT><FONT COLOR="#800000">c</FONT><FONT COLOR="#000000">=</FONT><FONT COLOR="#000080">##class</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008080">bla.bla</FONT><FONT COLOR="#000000">).</FONT><FONT COLOR="#0000ff">%OpenId</FONT><FONT COLOR="#000000">(20)</FONT>

The only thing is that in this case Studio Assist will not work.

Vitaliy Serdtsev · Jan 2 go to post

A good thing to know is, that there isn't actually a thing as 'during compile time' in ObjectScript.

Do you think that the documentation contains an error?

##function Evaluates an ObjectScript function at compile time.
#execute Executes a line of ObjectScript at compile time.
##expression Evaluates an ObjectScript expression at compile time.

Vitaliy Serdtsev · Dec 29, 2025 go to post

There are nuances ;)

According to the documentation, the following two lines will give different results at the runtime:

<FONT COLOR="#0000ff">#dim </FONT><FONT COLOR="#800000">a</FONT><FONT COLOR="#000000">,</FONT><FONT COLOR="#800000">b</FONT><FONT COLOR="#000000">,</FONT><FONT COLOR="#800000">c </FONT><FONT COLOR="#000000">= </FONT><FONT COLOR="#000080">##class</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008080">Sample.Person</FONT><FONT COLOR="#000000">).</FONT><FONT COLOR="#0000ff">%New</FONT><FONT COLOR="#000000">() </FONT><FONT COLOR="#008000">; all the variables are assigned the same initial value
</FONT><FONT COLOR="#0000ff">#dim </FONT><FONT COLOR="#800000">a</FONT><FONT COLOR="#000000">,</FONT><FONT COLOR="#800000">b</FONT><FONT COLOR="#000000">,</FONT><FONT COLOR="#800000">c </FONT><FONT COLOR="#0000ff">As </FONT><FONT COLOR="#008080">Sample.Person </FONT><FONT COLOR="#000000">= </FONT><FONT COLOR="#000080">##class</FONT><FONT COLOR="#000000">(</FONT><FONT COLOR="#008080">Sample.Person</FONT><FONT COLOR="#000000">).</FONT><FONT COLOR="#0000ff">%New</FONT><FONT COLOR="#000000">() </FONT><FONT COLOR="#008000">; each variable is assigned a separate OREF</FONT>

Vitaliy Serdtsev · Dec 22, 2025 go to post

IRIS 2025.3.CE

ClassMethod test() [ Language = python ]
{
  import iris

  ns = iris.system.Process.NameSpace()
  try:
    iris.system.Process.SetNamespace('%SYS')

    passenger = iris.SYS.Stats.Dashboard.Sample()
    print(passenger.GloRefsPerSec)
  finally:
    iris.system.Process.SetNamespace(ns)
}

PS: Do I need a separate python iris connection for each Namespace?

Vitaliy Serdtsev · Dec 18, 2025 go to post

For each alphabetic character, determine its zero-based index in the lowercase alphabet (a-z).
Preserve non-alphabetic characters unchanged.

For clarify: does alphabetical characters include only the English letters a-z, A-Z, or all Unicode characters including "ªµºÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéyêëìíîïðñtóôõöøùúûüýþÿ" ?

What should be the correct result for the string "Hello World µÝ Привет Мир!" ?

Vitaliy Serdtsev · Dec 17, 2025 go to post

Your task is to implement this encryption efficiently

What does "efficiently" mean?

The condition of the Code Golf competition has always been to write the shortest code, not the fastest (see Code Golf Index)

User statistics