go to post Kevin Chan · Dec 30, 2021 Yeah, the JVM encoding problem has been discovered internally and we're actively trying to correct it.
go to post Kevin Chan · Dec 30, 2021 The %qparsets issue that you're seeing has been resolved internally and should be shipped as part of IRIS 2022.1.0
go to post Kevin Chan · Dec 30, 2021 To resolve the issues with airlines.dat, do the following Add to the JVM arguments of %Java Sever, "-Dfile.encoding=UTF-8" without the quotes Edit airlines.dat and make the following changes Replace "\N" which is a MySQL specific token with "" (i.e. the empty string). Due to specific interactions with InterSystem's JDBC clients with IRIS, "" is interpreted as NULL when inserted as a string. Replace "\\'" (the escaped apostrophe) with "'" (just the single apostrophe) as InterSystem's JDBC clients do not require the escape character (which would otherwise be required in SQL). This will allow all 6162 rows be inserted.
go to post Kevin Chan · May 3, 2021 https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...You can just do "SELECT TOP X FROM ...." where X is the number of rows you're looking for. As mentioned in the above link The TOP clause limits the number of rows returned to the number specified in int. If no ORDER BY clause is specified in the query, which records are returned as the “top” rows is unpredictable.
go to post Kevin Chan · Mar 29, 2021 Are you running $system.OBJ.Load("name of file") without specifying any qualifiers? If so, I believe the default qualifiers are "CUK" (compile, update only, keep source). You might want to try $system.OBJ.Load("name of file", "CK") and see if that helps.
go to post Kevin Chan · Mar 25, 2021 You can run a query like SELECT * FROM someTable ORDER BY %ID and it will order by the row ID without including it as part of the result set. Ultimately we would need more information (like the query you're running) to provide additional answers, but ORDER BY %ID sounds like what you want to use.
go to post Kevin Chan · Mar 17, 2021 $system.OBJ.IsUpToDate()might fit the bill for your first question. set sc = $system.OBJ.GetClassList(.classes) set cls="", outdated="" for { set cls = $order(classes(cls)) quit:(cls="") if '$system.OBJ.IsUpToDate(cls) set outdated = outdated _ $lb(cls) } for i=1:1:$listlength(outdated) { write $listget(outdated, i) } should work for your 2nd question (documentation here: https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic....)
go to post Kevin Chan · Jan 31, 2021 https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=RO... SqlFieldName
go to post Kevin Chan · Oct 1, 2020 Create a simple %Status like set status = $system.Status.Error(5001, "This is an error") and if you do zwrite status status="0 "_$lb($lb(5001,"This is an error",, ....." I cut out a significant chunk (...) because it's not relevant. You can see that the first character in status is "0", that is because if you try a unary operator +status, -status, 'status It will evaluate to the integer 0 and effectively work as a boolean flag. The part that matters is after the "0" inside the $listbuild. The first element of $listbuild is the error code, followed by the message. Because you set Test to 0 and nothing else, Objectscript recognizes that as a failure condition but has absolutely no information to provide beyond that. The recommendation is that you properly assign Test as a fully qualified %Status or change it to a %String where its value is equal to $system.Status.GetErrorText(/* some %Status instance*/)
go to post Kevin Chan · Sep 12, 2020 If you're using IRIS 2020.2.0 or above (both target and source instances must be ^2020.2.0), you can try to leverage %Net.DB.Iris. It's an implementation of IRIS Native for Java/.NET/Python/Node except for Objectscript. If there is enough interest for features like %Net.DB.Iris, @Bob Kuszewski would love to hear about it and communicate that interest over to the development teams!
