All
Accepted answers
Enrico Parisi · Mar 5 go to post

Where else you can get in touch with so many IRIS delevopers, including InterSystems products developers?

Enrico Parisi · Mar 3 go to post

If you need " official recommendation" you should contact InterSystems WRC, this is a Developer Community.

Enrico Parisi · Mar 2 go to post

What type of ResultSet? Can you please provide the exact class name of the ResultSet you use?

Enrico Parisi · Feb 25 go to post

To get it working using DBeaver Community 25.3.5 I had to put the SSLConfig.properties file in C:\Program Files\DBeaver and then it works!

Thank you @Benjamin De Boe 🙂

Enrico Parisi · Feb 25 go to post

One option could be:

Set last=$o(^A(""),-1)

Set ^A(last_"z")="new last value"

In fact you can concatenate anything, not necessarily a "z"..

If the first subscript is always numeric, then:

Set last=$o(^A(""),-1)

Set ^A(last+1)="new last value"

Enrico Parisi · Feb 24 go to post

The first parameter is a $list, try with:

do ##class(%SYS.TaskSuper).ExportTasks($lb(1022,1023),"/opt/contenedor/tasks.xml")

Note that the documentation for the ExportTasks() method you linked in your post says:
List of task IDs to export $lb(1,2,3)

Enrico Parisi · Feb 20 go to post

Hi @Vitaliy Serdtsev thank you for your answer, however I need to reproduce the same interface/definition as currently implemented in Oracle that is using a CLOB column.

The JDBC client access the Oracle table and is implemented (for that column) using a CLOB that (I believe) it's different than accessing a LONGVARCHAR. The idea would be to use IRIS instead of Oracle without changing (most of) the code.

Where is defined/documented the JDBC LONGVARCHAR maximum length?
My search cannot find any reference on max size of 2147483647

Enrico Parisi · Feb 16 go to post

I think this is the expected behavior, in your sample code you are importing JSON to the same existing object, so it "add" (or update if you prefer) to the existing object.

If you want/need to import the JSON to a new object, then do so, and create a new instance before importing:

set r = ##class(User.ADGroup).%New()

Enrico Parisi · Feb 16 go to post

@Robert Barbiaux 


"return" is equivalent to "quit" with argument, thus is has only one form and one, clear meaning : returning a value.

Both Quit and Return can be used with or without an argument (returned value),  see the documentation for details.

RETURN and QUIT differ when issued from within a FOR, DO WHILE, or WHILE flow-of-control structure, or a TRY or CATCH block.

You can use RETURN to terminate execution of a routine at any point, including from within a FOR, DO WHILE, or WHILE loop or nested loop structure.

In the context of the main post/question example Quit and Return can be used and there is no difference, the behave the same way.

Personally I never use Return simply because I don't consider a good practice to exit a method in the middle of a FOR, DO WHILE, or WHILE flow-of-control structure, or a TRY or CATCH block, to me it's like, or worst, than using a GOTO command. In my opinion good code should have one exit point at the end of a method, not a random number of exit point in the middle of nested structure inside the method, therefore the newly introduced Return command is of no use for me. Again, this is my very personal opinion.

Enrico Parisi · Feb 7 go to post

How  can anybody help you without any detail of the routing rule used by your business process?

Enrico Parisi · Feb 6 go to post

I'm not sure it's a great idea, think about this code:

Set true="it's a good idea"
Set false="it's a bad idea"
Set dObj={"idea":true, "doubt":false}

😉

Enrico Parisi · Feb 5 go to post

Add %XML.Adaptor to the superclasses of all your classes, the trace message content viewer represents the class as XML.

Enrico Parisi · Feb 5 go to post

What's the line (segment) delimiter used in the stream? Maybe (likely?) $c(10), there maybe a message delimiter.

My suggestion is to save the stream into a file and then using an hex editor check what your stream actually contains and how is delimited.

Then, with this accurate info, you can split your stream in HL7 messages.

Enrico Parisi · Feb 5 go to post

"The rest of the structure that is referenced by the base Response.cls structure extends %RegisteredObject, %JSON.Adaptor."

A %RegisterdObject is not persistent, so it's never stored and therefore you cannot view in trace something that...does not exists (anymore).

Maybe an option could be to use %SerialObject instead of %RegisterdObject  

Enrico Parisi · Jan 31 go to post

@Vachan C Rannore, that's work for sure, BUT, the file will be exported in the IRIS SERVER filesystem, not "your" (where vscode is running) filesystem. In some environment you may not have (simple) access to the IRIS server filesystem.

The question is on exporting to your local machine, as usually done using Studio.

Enrico Parisi · Jan 27 go to post

Is the %Service_Bindings enabled with password authentication?

Check in Management Portal:
System Administration -> Security -> Services

Enrico Parisi · Jan 25 go to post

Can you please provide more details? What kind of "service"? What settings are you using?

Enrico Parisi · Jan 24 go to post

Usually in IRIS X509 certificate are configured in Management Portal:
System Administration -> Security -> X.509 Credentials

To configure it there the certificate must be stored in a file.

How/where you need to use the X509 certificate?