When I use jdbc driver to query the column info ,the "REMARKS" field always show the same as the "COLUMN_NAME" field.
When I use the sql "select * from INFORMATION_SCHEMA.columns a where a.table_name='some table name ' " to query columns info,there has a "DESCRIPTION" field ,the value is some comment for the current field.
So is there anyway to return the description to the jdbc remarks field? And is there anyway to update the desciption or remarks field? Or is there some other way that I don't know to manage column comment info?
Many password requirements can be enforced using a password validation routine which is available to implement in System Management Portal. But how about this one:
Check that at least 50% of the characters changed from old password to new password.
We need to have access to the old password to check this, currently password validation routine only gets the new password.
I encountered a strange issue I just can’t solve and I am running out of ideas. After reading the relevant passages of the documentation, asking the community is my last resort.
I am trying to investigate whether the SAM component will give us metrics that we are looking for when it comes to # of messages, etc... I have IRIS 2022.1 running on Red Hat 8, but noticed that SAM was bundled as a docker-compose image. REL 8 doesn't install docker off the bat, but has podman which reading podman 3 versions and later, I should be able to call docker-compose.yml images. After installing Apache and making some modifications to docker-compose.yml, I tried executing the start.sh script after verifying podman was running and podman-compose was installed.
I have a SOAP web service on an IRIS system. From within the code of the WebMethod I would like to log the remote IP address of the client. Is there any way to get access to the client's IP address from the ObjectScript code in the SOAP service? This will save me some headaches correlating logs from IRIS with web server logs.
I am receiving a JSON File as Stream container Using pRequest As Ens.StreamContainer and output as Output pResponse As %Persistent in a Custom Business Operation
I have tried to install the module git-source-control into my USER namespace, but get the following error.
ERROR! ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={2763|2764}> > ERROR #6084: Unknown errors detected, but no error code reported
Im playing whack a mole importing an IG (which is a fairly typical exercise with fhir packages) through FHIR packages, and getting at some parts I cant seem to work around with some store errors...
I am trying to use the IRIS connection to connect from our LIS to Health Connect (ENSEMBLE) directly. You can do this in the same namespace using this:
I am new to zen framework. I wanted to use Angular with in Zen framework. If we can integrate both frameworks. Please help me in finding some resources to refer.
My client is using IRIS 2021.1 Interoperability and they want to highlight the sessions with unresolved(without resent and completed operations) errors so their maintenance team can have a list of unresolved sessions to check against.
When I'm working on it, it seems to be it is is difficult to decide whether a session have unresolved errors. For example,
Does anyone have any pointers or maybe familiarity of making Email templates in Objectscript?
I'm currently trying to implement Televisits with our system and am needing to send an email to the patient. I'd like to make it a nicer looking email which will require a good amount of inline CSS. I currently have a method, but is very much a sore sight for the eyes.
I was wondering if there was a way I could use Embedded HTML and pass that into the DO msg.TextData.Write command with the ##class(%Net.MailMessage)?
I running a query and get the results inside a result set. Now I have to iterate through the result set many times. From the doc I've seen only the Next() method. Is there a way to reset the cursor? Otherwise what is a good data structure to save multiple rows of a table?
My code in this case is something like this:
set sql = "SELECT * FROM MY_TABLE WHERE X= '"_Y_"'" set status = ..Adapter.ExecuteQuery(.rs, sql) // somehow iterate the rs more than one time
I am trying to avoid parsing the SDA3 stream in each process. I am doing some section wise validation in different processes so i need to pass the SDA3 to each process.
When i pass that SDA3 stream that takes a lot of space in HD and takes a lot of time to parse the SDA3 object.
Is there any way that once i parse that SDA3 i can pass the same object to other processes, and i can save my storage and process that fast.
I cannot pass this by default to other process as non persistent object cannot be passed to another job(as per my finding).
I have a pair of servers configured as a mirror, each server sits in a separate data centre.
I have noticed that occasionally, the primary will report that the backup is disconnected in the Mirror Monitor, and I believe this to be due to connection conditions between the two data centres.
Hello, new user here ! My admin granted me all access to the domain I'm working on. Nonetheless, I'm unable to perform simple SQL queries such as creating a table or an index.
What I have tried :
Creating a table : within the namespace I've been granted access to, I'm trying to create a table with 2 methods :
I've faced a problem that happens while debugging a process in VSCode. It doesn't seem to matter if this is in a container, on my development VM, or against a locally installed version of IRIS. The problem seems to be mostly with X12 Documents.
So, in a debug session, I can dump out a value to the debug console and it loos correct. The same variable in VSCode appears to be some uninitialized memory location.
By update.png)
.png)