InterSystems Developer Community is a community of 25,310 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

II try to explore the new SQL LOAD DATA feature in SQL comparing it to SQL INSERT

I'm stuck at this point: INSERT INTO <table> (columns...) VALUES (.....)
allows having not just simple column references but also ALL Standard SQL FUNCTIONS (at least)
example:

INSERT INTO Test (ShortName,DOB) VALUES (SUBSTRING(Name,1,4),TO_DATE(displayDate,'MM-DD_YYY'))

This works perfectly.
BUT the same VALUE clause applied to LOAD DATA fails in various ways:

1 3
0 306
Hey Community,
Please check out the 2021 Annual Dev Community Article Digest with the most popular and commented articles. Thank you all for your contributions to the InterSystems Community in 2021!
General Stats
✓ 1,687 posts published in 2021:
– 234 articles
– 436 announcements
– 980 questions
– 37 discussions
✓ 2,451 members joined the Developer Community in 2021
✓ 8,930 posts published all time
✓ 10,287 members joined all time
6 7
0 438
Article
· Jan 13, 2022 2m read
Predict Maternal Health Risks

Hi community,

Prediction is a critical to the Maternal healthcare. The Health Dataset Application (https://openexchange.intersystems.com/package/Health-Dataset) has 10 real health datasets to predict the most important diseases and health problems, including Maternal Risk.

This article detail the steps to predict Maternal Risk using the InterSystems IRIS IntegratedML. This is a technology of InterSystems to do predictions using SQL Commnands! Great!

Follow these steps:

Open Exchange app
4 0
1 354

Hi Developers,

It's time to announce the Winners for December 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in December 2021:

🥇 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabi

🥈 @Sergey Mikhailenko, Chief Specialist, AO Mosvodokanal, Russia

🥉 @YURI MARX GOMES, Software Architect, YM Services, Brazil

Learn more about the competition and our awesome winners below.

5 7
0 292
Question
· Nov 30, 2021
Iris vs Java

Hello. I'm having problems migrating a java application that is running with cache 2018 to Iris
The application uses json generated by the cache to receive it as a string in java.

0 11
1 607
Announcement
· Jan 12, 2022
New Kubernetes Exercise!

Hi All! For those of you who attended experience labs at the 2021 Virtual Summit, you may recall that one of the lab sessions was around Kubernetes. We've now converted that lab to be fully on-demand. You can launch a small cluster of VMs and follow the exercise to manage your Kubernetes cluster, deploy InterSystems IRIS containers to it, and watch its self-healing nature when destroying a pod.

It's a great introduction to Kubernetes if you are interested! See here: Achieving High Availability with InterSystems IRIS and Kubernetes

3 0
1 270

Hey Developers,

You're very welcome to check the most-watched videos for 2021 on InterSystems Developers YouTube Channel:

Top 10 videos by views
№ Video Views
1 Active Directory Integration with LDAP 9 051
2 SMART on FHIR: The Basics 4 781
3 InterSystems Developer Ecosystem Services: Developer Community and Open Exchange 3 874
4 InterSystems API Manager: Gummy Bear Factories 3 866
5 Developing with FHIR - REST APIs 2 673
6 #VSummit21: "Who wrote this code? It makes no sense!” – the importance of software maintainability 2 383
7 Building Modern Web Applications 2034
8 Configuring a Web Server for IIS for Better Performance and Security 1992
9 ObjectScript with Visual Studio Code 1971
10 Building Health IT Apps with Artificial Intelligence 1963

3 0
0 300
Question
· Jan 8, 2022
SQL LOAD DATA date values

I have csv date file with date values like this "4/10/2021" for April 10, 2021. I defined a table with this property: Property TranDate As %Library.Date.

I capture error

[SQLCODE: <-104>:<Field validation failed in INSERT, or value failed to convert in DisplayToLogical or OdbcToLogical>] [Location: <ServerLoop>] [%msg: <Field 'dc_data_finance.transact.TranDate' (value '4/10/2021') failed validation Field ...

I do not really want to change TranDate to %String. How can I import "4/10/2021" into %Date property?

0 10
0 655

You might of seen or might of not seen my earlier post about Exporting a Production from 2018.1 to import it into 2021.1. I was able to get the export working, however I noticed in reviewing the data within the export, our previous Workday XML Schemas that we imported via XSD files were not in the export. When walking through the export process under Message Schema or vDoc Schema I could not find the missing XML Schema structures. Why aren't XML's part of the export process if they are used within the Production?

0 1
0 693

We are migrating from AIX to Linux and part of our testing is trying to figure the best method to migrate the code. I am trying to export an entire Production, however I keep running into an error...

Error generating export list for production osuwmc.TestClin and all items may not be listed.
ERROR #5002: Cache error: <CLASS DOES NOT EXIST>zgetRecordandComplexMapClasses+34^Ens.Config.Production.1 *(No name)

I went through any Complex Record Maps, and recompiled them but I am still getting the same error

0 3
0 312

Hey Developers,

We have a requirement to develop SOAP webservice from existing wsdl. Consumers are currently consuming existing soap webservice exposed by other provider.

We need to implement same SOAP service in ensemble as consumers should not see any difference except endpoint url.

Here we need to develop SOAP service form existing WSDL, which is possible in java. Is it possible in ensemble?

Could you please give me some hints to way forward.

Thanks,

Prashanth

2 2
0 348

Hi folks!

Sometimes we need the docker image of the InterSystems IRIS solution we build to be published on some docker registry. The cases could be:

  1. Deploy it then in Kubernetes cluster
  2. Let your pal run the image of your public repo without building it locally.

You can push the image to Docker Hub Registry or Github Registry.

In this very short article, I provide a way how to do it automatically on every push to your GitHub repository.

Open Exchange app
3 0
2 359

Hello developers, I'm a newbie to Intersystems technologies and I started to work with Caché and Ensemble, and to be more specific I'm working with systems integration. In a scenario where I need to develop new software from scratch, would it be better to develop this new software using REST APIs? Does anyone have any recommendations about courses?

0 3
0 387

or "So you just got yelled at by your boss, for sending him an unformatted Hello World webpage"

Our previous lesson ended with us serving a Message value obtained from a Caché REST service to the client, using Angular as a runtime. While there is a lot of moving parts involved in this process, the page is not especially exciting at the moment. Before we can start adding new features, we should take a step back and review our tools.

12 1
1 2.7K