when using $zt($P($H,",",2)) from terminal it gives the correct local server time but when using it in my cache code it gives an incorrect time (5 hrs difference)

but from the code it gives 13:14:54 !?


0 4
0 124

I'm trying to keep all writes in local memory.

If you have S %A="""HI THERE"",!,#,33.33,"" "",$ZTIMESTAMP"

and you O 2 U 2 W @%A C 2 ZW ^SPOOL
^SPOOL(1,1)="HI THERE"_$c(13,10)
^SPOOL(1,3)="33.33 67016,59246.6188873"

It works just fine and the output is in the ^SPOOL global.

However, I'm trying to avoid writing to disk.

I can't find anything besides using the SPOOL device that will allow the use of the "@" indirection.

0 4
0 114
· Jul 3
Polybase and IRIS

Hi all, I am trying to use Polybase in SQL Server 2019 to access an external Cache/IRIS Database. I have followed the initial steps of enabling Polybase, creating a Database, DB scoped credential and then an External Data Source. These steps have not caused any issues and appear to be successful, I am using the same DSN we use for a Linked Server connection that works normally. I am running into an Error when trying to Create an External Table. The error is a generic Native Code 469 "Driver Not Capable".

0 2
0 76

Our client getting sometimes this error and we need to change port number on JavaGateway process to continue,

Failed to start the Gateway server: ERROR #5023: Remote Gateway Error: Communication failure on port: 5000
> ERROR #5001: External Language Server: invalid ping response

Can you tell as why it is happenning? intersystems runtime is under linux.

0 6
0 65
· Jun 27
ZF(-100) and qpdf


I have seen your post on using qpdf with the zf(-100) function and was wondering if you could be so kind to share an example line of code. I can use pdf from the DOS command line no problems with the following:

qpdf --encrypt test123 test123 256 -- c:\test\basement.pdf c:\test\basementenc.pdf

Trying the following from the iris terminal I get a RET=2 in messages.log and the PDF is not created.

d $ZF(-100,"/logcmd", "qpdf", "--encrypt test123 test123 256 --", "C:\test\basement.pdf", "c:\test\basementenc.pdf")

Kind Regards,


1 1
2 65

Could any one tell me, how the index works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as


and the table data be like


001 ABC 20

002 AAA 21

003 ABB 23

004 BBB 20

005 BDF 24

006 EEE 22

0 2
0 58

I have an HL7 message that contains NTE segment with line break inside.

when I try to transform it (with DTL) it stops reading the message after the line break inside the NTE because it treat that as "End of Message".

Is there a way to solve this in the DTL or I need to run a pre process on the HL7 message that identify the line break inside the NTE segments and replace it with an escape char?

1 1
0 55


Depuis ce matin j'arrive pas à compiler ou lancer mes programmes qui tourne en local sur docker avec l'image : intersystemsdc/irishealth-community:2024.1-zpm

J'ai toujours cette erreur sur le terminal ou le portal de management : request to http://localhost:52773/api/atelier/ failed, reason: socket hang up

Dans mes logs docker aussi j'ai des erreurs en conitnu , voici un extrait ...

0 1
0 51
· Jul 16
Add Zen component

Hi Guy,

I'm currently using a classmethod to load my page's display content in a form of html want look good, I'm wondering if I can add a Zen component in my classmethod eg. <dataCombo> or Label...etc?

I've tried the bit of code (circled in red) but didn't work


0 4
0 44

Hi all,

When passing on the content of a file in a REST API call, I need to put the original file name in an HTTP header. As it happens, some file names have non-8-bit characters in them ("å", "ö", and the like), and these arrive garbled on the other side. Does anybody know the correct way to encode them (assuming they should be encoded at all)?

$zconvert(filename, "O", "UTF8") does not appear to be it. I'm leaning towards $zconvert(filename, "O", "URL"), but leaning isn't good enough.


0 1
0 40