I'm getting an unexpected behavior when using pandas function to_sql(), which uses sqlalchemy-iris. After the first execution, a transaction seems to be opened and all rows inserted are lost after closing the connection:
I'm a bit confused about the number of elements in an XML object. I have an object of the class EnsLib.EDI.XML.Document The xsd structure ( DocType) is an SDA Object
Hi, I'm working on a large extraction from a database and need to parallelize the processes during the extraction.
Here's what happens:
The user starts the extraction from.
Several jobs are started using the Job <Method> instruction.
At the end, the user expects to find a document containing the results of all the extractions. What I'd like to do is start a new job that checks whether the previously started jobs have finished or are still working and consequently produce the document.
we converted from Ensemble 2014 to 2018 and now getting the attached error which looks like Manage Method don't exist anymore, has it been replaced by a new one?
we are trying to access a windows file server from our file adaptor, which has been setup using a Linux CIFS mount The mount requires a user/password to access the files on the windows server. How do we get the integration engine to pickup the right username/password?
I am trying to create a HS.FHIR.DTL.vR4.Model.Resource.Encounter message based on a conversion of HS.FHIRServer.Interop.Response QuickStream to a JSON %Dynamic Object.
When I try to send the HS.FHIR.DTL.vR4.Model.Resource.Encounter onto the Router
i use %SYSTEM.WorkMgr to handle data by multicompile=1,but i find that,after WaitForComplete,the processes created by %SYSTEM.WorkMgr are still stand by,
I have an SQL table as below (columns - ID and Value)
I will get an ID number (first column) as an input from FTP inbound , and after that I have to query table taking ID as an input to get all the values for the ID
as -
if ID = 11 ; QRY output = aaa,bbb
if ID = 22 ; QRY output = xxx,yyy,zzz
can someone help me with query
ID Value ---------- 11 aaa 22 xxx 22 yyy 11 bbb 22 zzz -----------
https://www.youtube.com/embed/fqSL7FuBsYM [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]
Is there a general way to set a variable XYZ equal to the text of thecode line being executed now? Debugger or production. For example, for a code below if code is currently assigning a to 1, XYZ would be equal "S a=1". The same question about a variable containing current routine name.
I've recently updated the python version of a linux server running Red Hat Enterprise Linux 8.10 (Ootpa). We have an instance 2023.1 running there, and whenever I run the $System.Pyhthon.Shell() I can see it's still pointing to the old version. From within linux, it runs the latest one (we've change all the links to the new 3.11, so no scripts are broken).
So I guess the problem comes from the fact irispython is still compiled using old python version. So, how can I do to force IRIS to use the current version on the server, or update the irispython file?
We are third party vendor who acts as a buffer between the customer and intersystems to purchase licenses for intersystems. I am wondering can we use AWS license manager to manage the IRIS licenses on behalf of our customers?
We have an ObjectScript application that runs in Cache' and IRIS. Our typical installation involves a .zip file containing several files necessary for the installation and operation of the application. Steps are: expand the .zip file to a folder that will not be used by the application. Do ^%RI for the installation routines in the production namespace. Do the Installation routine. We have a customer that is trying to do a silent installation. He does not want to have to respond to any prompts on the installation.
Hello, I try to develop a REST interface where I need to interact with legacy MUMPS routines. How can I pass in input to a Read without modifying the legacy code?
I think in linux I can execute command < inputfile to read from file, but how does it work in ObjectScript?
I have a requirement where in I had to read a HL7 message string ( which is a String ) from a SQL TBL to my Business Service. and I need to convert that string to EnsLib.HL7.Message format and traverse through the PID segment.