go to post Eduard Lebedyuk · Mar 23, 2022 Try: set $ZSTORAGE=-1 I worked with 12 GB json objects and it was all fine.
go to post Eduard Lebedyuk · Mar 17, 2022 What does this code return for you: Class test.ts Extends %Persistent { Property ts As %TimeStamp(MINVAL = "0001-01-01 00:00:00.000"); /// do ##class(test.ts).Test() ClassMethod Test() { set obj = ..%New() set obj.ts = "1800-12-25T00:00:00" set sc = obj.%Save() if $$$ISERR(sc) { write $System.Status.GetErrorText(sc) } else { write "Save successful" } }
go to post Eduard Lebedyuk · Mar 17, 2022 By default timestamps are limited to December 31, 1840, same as horolog. If you want earlier dates, timestamp property must be defined as: Property ts As %TimeStamp(MINVAL="0001-01-01 00:00:00.000");
go to post Eduard Lebedyuk · Mar 14, 2022 Does your IRIS license include InterSystems BI (DeepSee)? In that case you can use that. Depending on what exactly do you want to do, KNIME might be a solution (if you're ok with self-hosting HTML files as KNIME server is a commercial product). But most BI tools are proprietary. Any tool which support xDBC datasources can work with InterSystems IRIS.
go to post Eduard Lebedyuk · Mar 10, 2022 You can replace: Set tQuery = "GRANT EXECUTE ON %Library.RoutineMgr_StudioOpenDialog TO VSCODE" Set tStatement = ##class(%SQL.Statement).%New() Set tSC = tStatement.%Prepare(tQuery) Set tResultSet = tStatement.%Execute() with: Set tSC = ##class(%SQL.Statement).%ExecDirect(, "GRANT EXECUTE ON %Library.RoutineMgr_StudioOpenDialog TO VSCODE") Still, unfortunate there's no object way to do that, only relational. And %EnsembleMgr:addSQLPrivilege is private.
go to post Eduard Lebedyuk · Mar 9, 2022 Add a role with execute on StudioOpenDialog to /api/atelier web app?
go to post Eduard Lebedyuk · Mar 9, 2022 Use this: import datetime horolog = 66177 datetime.date.fromordinal(672046+horolog) fromordinal counts days from 1st Jan 1, $horolog counts days from 1st Jan 1841, so to get ordinal date from horolog date you need to add ordinal value of 31st Dec 1840 which is 672046.
go to post Eduard Lebedyuk · Mar 7, 2022 Ah, no. Won't work without parenthesis. For example "0Z" would return true instead of false.
go to post Eduard Lebedyuk · Mar 7, 2022 That was about my idea too. Clever trick getting rid of the parenthesis!
go to post Eduard Lebedyuk · Mar 5, 2022 Write a classmethod: ClassMethod GetStatus(dbFolder) As %String { new $namespace set $namespace = "%SYS" set db = ##class(SYS.Database).%OpenId(dbFolder) quit db.GetStatus() } And call it from Python.
go to post Eduard Lebedyuk · Mar 5, 2022 GetStatus is available in 2017.1 but it's an instance method, not a class method, so you can't call it this way. You need to wrap it in a class method.
go to post Eduard Lebedyuk · Mar 3, 2022 You can update your IRISHealth instance from 2019 version to 2021.