$zdth()

USER>w $zdth("2021-11-04T11:10:00+0100",3,5)
66052,40200

In this case, you can do this:

SELECT %TSQL.ZRAND(%ID+1e16) rnd,
ID, Citizenship, DOB, FirstName, Gender, IDNumber, LastName, PatientNumber, PhoneNumber
FROM CDR.Patient

Type of rnd - DOUBLE.
Of course, you can convert it to NUMERIC or STRING

Try calling the ClearBuffers in the GLOBUFF system routine, e.g.:

USER>d ClearBuffers^|"%SYS"|GLOBUFF()
Removed 65303 blocks

Try Built-in Modal Groups

E.g.:

Class dc.test Extends %ZEN.Component.page
{

XData Contents [ XMLNamespace = "http://www.intersystems.com/zen" ]
{
<page xmlns="http://www.intersystems.com/zen">
  <tablePane id="tp" sql="select 1 id, '2021-11-03' DT union select 2, '2022-01-24'">
    <column colName="id"/>
    <column colName="DT" link="javascript:zenPage.modalGroupCalendar('#(%query.DT)#');"/>
  </tablePane>
</page>
}

ClientMethod modalGroupCalendar(val) [ Language = javascript ]
{
  var group = zenPage.createComponent('modalGroup');
  group.setProperty('onaction','zenPage.calendarAction(group);');
  group.show('Select a date:','calendar',val);
}

ClientMethod calendarAction(group) [ Language = javascript ]
{
  alert("You selected: " + group.getValue());
  // SaveOnServer(); !
}

}

Try this:

Class dc.test Extends %ZEN.Component.page
{

XData Contents [ XMLNamespace = "http://www.intersystems.com/zen" ]
{
<page xmlns="http://www.intersystems.com/zen">
  <tablePane id="tp" sql="select 1 id, 'a' FollowUp union select 2,'b'">
    <column colName="id"/>
    <column colName="FollowUp" header="FollowUp Comments" width="9%" style="text-align:left;" OnDrawCell="txtFollowUp"/>
  </tablePane>
</page>
}

Method txtFollowUp(
  pTable As %ZEN.Component.tablePane,
  pName As %String,
  pSeed As %String) As %Status
{
    &html<<textarea name="followup" rows="3" style=" width: 95%;" onchange="zenPage.saveFollowUp(this.value,#(%query("id"))#);">#(%query(pName))#</textarea>>
    Quit $$$OK
}

ClientMethod saveFollowUp(
  val,
  id) [ Language = javascript ]
{
  zenAlert(val,' <-> ',id);
}

}

This functionality is available when working with ActiveX (however, ActiveX is not recommended for use in new applications):

• Using Callback Functionality
• SetOutput()

PS: in the Caché distribution there was even a special library DelphiCallback.dll for Delphi, an example of working with which is in my blog.

I did a small test locally (for Caché).

test.py:

print("success")

exit()

From terminal:

USER>w $zf(-1,"python C:\tmp\test.py")
0

From Studio Output Window:

w $zf(-1,"python C:\tmp\test.py")
0

Make sure that your service for Caché/IRIS use an account with administrative rights:

• Windows User Accounts
• Changing the InterSystems Service Account

It should be like this (see Work with multiple sql statements):

DELETE FROM TableName WHERE ID = 2
GO
DELETE FROM TableName WHERE ID = 3
GO
DELETE FROM TableName WHERE ID = 4
GO

See my old article on my blog: Examples of generating and sending Email using the Caché DBMS (this is machine translation)

For more details, see the documentation on Caché, for example: Namespace tab of the Studio Workspace window (and not Project tab)

And more (see screenshot)

Those experienced with encryption systems for databases may have concerns about encryption having dire effects on performance, but, with Caché, these concerns are unfounded. Encryption and decryption have been optimized, and their effects are both deterministic and small for any Caché platform; in fact, there is no added time at all for writing to the database.

Managed Key Encryption: Protecting Data on Disk

InterSystems recommends using its encryption management tools:

• When built-in hardware instructions are available for encryption-related activities, these activities are considerably faster then when using software-based encryption. The encryption management tools use hardware instructions when they are available.
• The encryption management tools can use keys stored on a KMIP server.
• The encryption management tools can run in FIPS mode.

About Encryption Management Operations

High-Performance Encryption for Databases in Financial Services (PDF)