Is it planned that LOAD DATA takes into account several DATE/DATETIME formats with, for example, a parameter indicating the format used in the source data?
example :
LOAD DATA .../...
USING
{
"from": {
"file": {
"dateformat": "DD/MM/YYYY"
}
}
}
A bit of an old school CSP question. <csp:search> is a really nice, quick way to make easy lookups for CSP pages, especially for back office stuff that doesn't need to look pretty for the modern web app user.
hi,
I followed the example of the system and wrote a method to connect to an external database to obtain a result set, but I couldn't get the result.
can anyone please help on this.
I am using %Library.ResultSet to execute my query which I have something like this. Query GetABC() As %SqlQuery [SqlProc]{
}
After I execute this query and a resultset it returns from this. Now What I want to know is the SQL statement which will have the values dynamically added into while execution.
I am trying to fetch resultset using the below code -
set rs = ##class(%ResultSet).%New("Simple.Person:ValidateAge")
do rs.Execute()
it is giving me error while the same code I run it through iris terminal worked fine. I want to understand that problem behind this. Also how can I check the possible methods that I can use on 'rs' somewhat dir() does in python.
I am using ExecDirect() method to get SQL resultset of type %SQL.StatementResult.
now I am fetch a column something like this rs.%Get("Amount") but if amount column is empty then it is return me empty string. If There is any way to set something like this in IRIS rs.%Get("Amount",0.00) if that is possible.
In show Query messages in the message viewer the head.%Id is always used. How do you do this via your own sql/objectscript as fast as the portal does a search as using dates searching Ens.MessageHeader on portal is slow.
For instance if you try do a search saying (TimeProcessed >='2023-06-01 00:00:00.000' and TimeProcessed <'2023-06-02 00:00:00.000') it is slow but using the portal the search would know this is head.%ID >= 5344549861 AND head.%ID <= 5347641372. How do you utilize this in your own queries as can't see the logic in EnsPortal.MsgFilter.Assistant
Hi all, I am using ExecDirect() method to execute my SQL query which is something like "SELECT * from Account where AccountNumber = ? " But when I am providing a accountnumber that don't exists it doesn't return anything as aspected. while I am trying to check resultset.%SQLCODE in this case it is giving me 0 not 100. What's wrong with my SQL query and Also I there any other Property through which I check for if my resultset is null or it has some values.
I am trying to execute my SQL query using ExecDirect() method and it returns a ResultSet. No doubt it works fine after this I am trying to fetch each value using a loop code below. But before that, I am also checking for %SQLCODE = 100 which is for an empty resultset I think. However, It is not working as desired. In the case of an empty resultset also I am getting %SQLCODE = 0 until result.%Next() is called. Also, %ROWCOUNT is giving 0 in a case where my query is return 1 result row. I am so confused about this. while resultset.%Next() {
Do you know if there is any way to disable the automatic tuning IRIS is doing every time a class is altered? It just takes too long in our case and is holding the system, so I'd like to tune the tables when I decide it (again).
I've seen in the documentation that for 2023 version there is an option present in the backend. But not for 2022, so I assume a flag is needed somewhere.
How to read the HL7 V2.5 messages irrespective of message type to Iris database ?
Source system sends HL7 messages of multiple message types to Intersystems through TCP and these messages are to be inserted/read into iris SQL database.
Ran into an issue with our upgrade from HealthShare Health Connect 2018.1.3 to IRIS HealthShare Health Connect 2022.1, that I thought I would reach out about, I already have a ticket open with WRC and started a chat on Discord. We have a couple of MS SQL tables that I have setup as Linked Tables within Cache to query NPI, Patient Account Information, Visit information, etc... When we upgraded last week we found that within a day or even a half a day that we were having problems with our JDBC connections.
If I had: ________________________________________ Class MN.Student Extends %Persistent { Property Name As %String; ________________________________________ Class MN.Course Extends %Persistent { Property TeacherName As %String; Relationship StudentName As MN.Student [ Cardinality = one, Inverse = Name ]; ________________________________________
For "Cardinality = one" the SQL line below would be sufficient for archiving INSERT INTO MN.Course (TeacherName, StudentName) VALUES ('Pierre','3')"
On an IRIS system, we expect the default string collation for SQL columns to be SQLUPPER. This means WHERE conditions will be case-insensitive. However, when I make a WHERE condition on a SQL procedure that returns a string, it's case sensitive.For example:
Most of the databases with SQL access offers the DATE_TRUNC function or analogs. This helps to easily truncate a date by any part while keeping the DateTime in a valid format
We are migrating to new servers, and I need to copy the information from Business Partner's over to the new server. Is this information in a Global or SQL table somewhere that I can export and import into the new IRIS environment?
For my recent tutorial, I used %Query Wizard of Studio.
Could any of the VSCode experts please show me how to generate
Query Statement with input parameters, CONTAINID , ROWSPEC and the required class methods - <queryname>Execute() - <queryname>Fetch() - <queryname>Close()