Do we hv any command to prevent the execution of update/delete SQL w/o “Where” Clause？ 

In the last years the data architecture and platforms focused into Big Data repositories and how toprocess it to deliver business value. From this effort many technologies were created to process tera and petabytes of data, see:

The fundamental piece to the Big Data technologies is HDFS (Hadoop Distributed File System). It is a distributed file system to store tera or petabytes of data into arrays of storages, memory and CPU working together.

I need to remove content below, from PID-3/HL7 message, in IRIS. However, I need to keep the content in PID-3.1. For example, I’d need to keep only, “5050532”. Can this be done in Data Transformations? If yes, how?
Thank you!

MSH|^&|TEMPUS|TEMPUS LABS|EPICEMR|YRMC|20210930100824||ORU^R01|4823623379495310173|T|2.3| PID|1||5050532^^^YRMC09abefb8-872b-4147-8e4b-77463bb235cb^^^^TEMPUS||

Hi Community,

The InterSystems IRIS has a good connector to do Hadoop using Spark. But the market offers other excellent alternative to Big Data Hadoop access, the Apache Hive. See the differences:

Source: https://dzone.com/articles/comparing-apache-hive-vs-spark

I created a PEX interoperability service to allows you use Apache Hive inside your InterSystems IRIS apps. To try it follow these steps:

1. Do a git clone to the iris-hive-adapter project:

$ git clone https://github.com/yurimarx/iris-hive-adapter.git

2. Open the terminal in this directory and run:

$ docker-compose build

 Virtual Summit 21 is only a week away, and our Experience Labs are filling up fast. Register today (for the summit, then for the labs).

hello!

i have object bellow

Set object = ##class(%ZEN.proxyObject).%New()
set object.city = "New York"
set object.Target = "TEST" 
set object.Details = "TEST"
set object.RefCode = "123"
set object.Reason = "123TTTT"

I want to get string from json object. 

Could you help please ?

We need to use SOAP API for some webservice. I created the request/response & operation classes via the SOAP wizard. Prior to making the invokeMethod, 

..Adapter.InvokeMethod

i need to set a custom HTTP header as part of the SOAP call. Can you please let me know how i can set that. That Adapter ( EnsLib.SOAP.OutboundAdapter) class does not have methods for setting HTTP headers.

Thank you,

Ravi

Ensemble Log lost connection to arbiter, but no log in Windows, how to confirm connection did lost?

The InterSystems Certification Team is building an InterSystems IRIS Integration Specialist certification exam and is looking for Subject Matter Experts (SMEs) from our community to help write questions. You, as a valued InterSystems community member, know the challenges of working with our technology and what it takes to be successful at your job. In exchange for your assistance you will be compensated up to $500 per work assignment.

Hello Everyone ,

From Serial Device , i am getting only <CR> as line terminator , but ensemble expects <cr><lf> as line terminator . I couldnt change Line Terminator values in parser . Need help please

Thanks

Shilpi 

Hi,

Production is not auto starting even by adding  <Production Name="myProd.Production" AutoStart="1"/> in installer.cls file:

Thanks

If I open a terminal and type the following commands, sc is an error:

set validator = "sc = ##class(%Library.Numeric).IsValid(""BLAH"")"
set @validator
write sc

At the end, when I write sc I get:

0 L'BLAH9
             DOCXT010,#e^zIsValid+1^%Library.Numeric.1^1e^^^1

However, if I call the following class method using the arguments "%Library.Numeric" and "BLAH", sc is undefined

 ClassMethod testvalidator(class As %String, value As %String) As %Status
{
set validator = "sc = ##class("_class_").IsValid("""_value_""")"
write validator,!
set @validator
write sc,!

I work as an Integration Engineer for United States Department of Veterans Affairs (VA). I work on a Health Connect production which processes many RecordMap files. I do not fully understand RecordMaps and I wanted to develop an application for the Interoperability contest where I could learn more about working with RecordMaps. I browsed InterSystems documentation for inspiration on how to start. I was happy to find CSV Record Wizard. I had created a CSV file for my Analytics contest entry. I wanted to use it to test the CSV Record Wizard. It was not obvious how to use it.

Hi,

I am getting below message while generating package from ZPM

ERROR! ObjectScript error: <CLASS DOES NOT EXIST>zGenerateModuleXML+21^%ZPM.PackageManager.1 *%ZPM.PackageManager.Developer.ModuleTemplate

Thanks

Hey Developers,

Welcome to the next InterSystems online programming competition: 

🏆 InterSystems Interoperability Contest 🏆

Duration: October 04-24, 2021

Our prize pool increased to $9,450!

Hello everybody,

I am trying to export a class to xml and remove the tag "xmlns" from mother class. These are my classes to create the XML.

Class Class.Test Extends (%RegisteredObject, %XML.Adaptor)
{ 

Parameter NAMESPACE = "http://mynamespace.com/test"; 
Property Person As Class.Person; Property Address As Class.Address; 

}

Class Class.Person Extends (%RegisteredObject, %XML.Adaptor)
{ 

Parameter NAMESPACE = "http://mynamespace.com/test"; 
Property name As %String; Property age As %String; 

}

Class Class.Address Extends (%RegisteredObject, %XML.

First of all thanks for your time reading this question, and thanks for your help

We have the following use case: we would need to send with MTOM a zip which contains a csv

We have read:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?

Hello All,

I am receiving this error when attempting to place a file in a local SFTP server. 

ERROR <Ens>ErrFTPPutFailed: FTP: Failed to Put file '101320210700.RAW' (msg='Error in SFTP Put('/healthshare/mgr/Temp/VPacx9a1eq0b5g.iostream','/SFTP/unmhsmcsa/OUT/101320210700.RAW') ERROR #7504: Timeout',code=0)

Any help is appreciated.

Below are my settings

Hi guys,

how to clear selection in a table pane?

Thanks

Just in case you never heard about OFX before
V1 was an attempt to create a dedicated SGML for banking and ignoring XML. Details.
It evolved to XML but not for M$ MONEY. Today we would use JSON for similar tasks.

The latest release of Serenji focuses on the debug experience. Not only can you now debug on the spot, no matter where you are or what you're doing, but we've also added some smaller features that will make debugging more straightforward. 

• Run and Debug CodeLenses - clickable links above each class method, procedure, subroutine or extrinsic function.
• Intuitive prompting for entrypoints and arguments - when debugging a class method, produce, subroutine or extrinsic function. 
• Shaded read-only background - to clearly differentiate between documents which are editable and those that are read-only. 
• Program output in debug console - output is shown in the debug console. 
• Serenji commands on Server Manager's namespace trees - allowing you to launch Serenji through Server Manager. 

Find out more in our release notes here. 

Class abc.abcmh [ DdlAllowed ]
{ ClassMethod FetchMsgCount() As %Integer
{
    set msgCount=-1
&sql(SELECT count(ID) INTO :msgCount FROM Ens.MessageHeader)
If SQLCODE=0 Quit msgCount
Quit SQLCODE
}
 

This class method always giving -30 , means Table does not exist.

note: my namespace extends %sys

It appears the link to download IRIS is down:
https://download.intersystems.com/download/login.csp

That's Tuesday, October 26 at these times:

10 a.m. EDT| 11 a.m. BRT | 3 p.m. BST | 4 p.m. CEST

8 a.m. ICT | 9 a.m. SGT | 9 a.m. CST | 10 a.m. JST | 12 p.m. AEDT | 2 p.m. NZDT

Don't Delay. Register Today

Hi everyone!

I am trying to localize text in an XData block using the $$$Text macro. A snippet of code is included below. Is there an easy way to localize the text included in an XData block? So far, using the $$$Text macro is not working; when I export the %MessageDictionary, the text to be localized isn't included in the export.

XData LocalizedEmail [ MimeType = text/html ]
{
<body>

Text to be translated into another language

}

Thank you in advance!

Hey Developers!

We're pleased to announce the next competition of creating open-source solutions using InterSystems IRIS or IRIS for Health! Please join:

⚡️ InterSystems Interoperability Contest ⚡️

Duration: November 2-22, 2020

Hi,

I have CSV file in github repository. I want to import CSV file data into container class during running container. 

Thanks

I have written below method inbound adapter myAdapter Extends Ens.InboundAdapter [ ProcedureBlock ] returns -400

If i have written in any other Extends %Persistent  cls , always returning -30 which means Table not found

ClassMethod FetchMsgCount() As %Integer
{
    set msgCount=-1
&sql(SELECT count(ID) INTO :msgCount FROM Ens.MessageHeader)
If SQLCODE=0 Quit msgCount
Quit SQLCODE
}

Could you please some one tell me where should write this class method? What I am doing wrong?

Thanks

PRASHANTH

Hi, Community!

When I introduce a field to a persistent class to manage date/time what datatype should I prefer? 

%Date or %TimeStamp? And why?