#InterSystems IRIS

Hi, we are trying to run a dynamically generated Oracle Insert SQL script using Do $SYSTEM.SQL.DDLImport("Oracle",""," sql.txt",[Error Log]) to insert multiple rows into a Linked Table within HealthConnect to an Oracle database.

We have tried using statements that are accepted within Oracle but not when using Intersystems DLL along the lines of :

Hi.

Is it possible to set in XData mappings (or any other way) to serialize the property value as display value rather than value it self?

Regards,
Matjaž

Is there a way to access a SOUNDEX function from ObjectScript? There is such a function in the multivalue basic dialect and also one used by Patient Index.

Hi all

I'm testing migrating our existing installers (without ZPM) using the docker dev template as a basis with a commercial image and licence key.

So far everything builds as I expect, but the one issue I have is the production doesn't apply itself automatically.

In my iris.script I have custom installer that uses this manifest below but it does not observe the last three steps

Hi, ObjectScript experts!

I know that there are auto-generated getter and setter methods for class properties in ObjectScript.

Are there auto-generated getter methods for class parameters?

How do I create recursive classmethod which stop all methods from running when condition are meet?

I want to add a database to a mirror.

Is this the correct way to do so:

set status=##Class(SYS.Mirror).AddDatabase("/db/iknow")

Is the status=0 if it worked and anything else means it failed?

Thanks for any help

All,

Trying to download IRIS from the left menu.

Have been getting this error:

I originally contacted support as noted in the alert on 12/20/22 and have yet to get a response.

Any idea of how I can get the software?

Thanks!

I use the following code to grab 509 certificate and show private key :

If I had:
________________________________________
Class MN.Student Extends %Persistent
{
Property Name As %String;
________________________________________
Class MN.Course Extends %Persistent
{
Property TeacherName As %String;
Relationship StudentName As MN.Student [ Cardinality = one, Inverse = Name ];
________________________________________

For "Cardinality = one" the SQL line below would be sufficient for archiving
INSERT INTO MN.Course (TeacherName, StudentName) VALUES ('Pierre','3')"

How Job command can be used with Embedded Python code?

Hi All,

I am trying to fetch resultset using the below code -

set rs = ##class(%ResultSet).%New("Simple.Person:ValidateAge")

do rs.Execute()

it is giving me error while the same code I run it through iris terminal worked fine.
I want to understand that problem behind this. Also how can I check the possible methods that I can use on 'rs' somewhat dir() does in python.

Hi,

We're using a database gateway from IRIS to Oracle using ODBC. It has been occurring a character set issue that invalidate special characters.

Oracle support has found data type missmatch in ODBC debug while transfering data between the databases.

ODBC was download from official website.

Is there any Intersystems contact to send it to check whether there is a ODBC issue? I hasn't found any directy contact in Intersystems in website.

I'm using a customised IRIS Community Edition Docker Container: Node.js has been added and the Native API for Node.js directory moved to a node_modules folder in /home/irisowner. I've changed the _SYSTEM password using the Management Portal (which connects to IRIS just fine)

If I shell into the running container and try to connect with a JS script file containing this:

const IRISNative = require('intersystems-iris-native');

let connectionInfo = {

host: 'localhost',

port: 1972,

ns: 'USER',