How can we insert into a table using a stored procedure?

Table structure :

CREATE TABLE SampleHospital (
Hospital VARCHAR(50),
Location VARCHAR(50),
UserName VARCHAR(50),
UserFullName VARCHAR(70),
LastLogin TIMESTAMP,
LoginCount int)

Procedure Name:

call Custom_MENS_Other.samplesp('2021-11-02','2021-11-04','H001')

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

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in August 2022:

New Videos
№ Video Views
1 InterSystems Interoperability Contest: Building Sustainable Solutions 2737
2 What is Embedded Python 917
3 Integration Features of InterSystems IRIS 634
4 Using the Business Process Designer in InterSystems IRIS 598
5 Transforming Healthcare Messages in InterSystems Integrations 473
6 Creating Complex Decision Logic with InterSystems IRIS 253
7 Machine Learning 201 - Neural Networks and Image Recognition 193
8 [Webinar] Scaling InterSystems FHIR Server on Amazon Web Services with ECP 172
9 InterSystems Developer Ecosystem at Global Summit 2022 147
10 InterSystems at MIT Grand Hack 2022: Final 51
11 Interoperability Contest Kick-off Webinar: Building Sustainable Solutions 40
12 Women's Health - Femtech panel with industry leaders & entrepreneurs 39

0 0
0 176

I am looking for an Intersystems Developer for a long-term project in the medical field.

Please check out the job description below and feel free to send me a message if you are interested in learning more.

Contact me in any way that is convenient for you:

0 0
0 405
Article
· Sep 2, 2022 1m read
Reviews on Open Exchange - Aug. 2022

If one of your packages on OEX receives a review you get notified by OEX only own YOUR package.
The rating reflects the experience of the reviewer with the status found at the time of review.
It is kind of a snapshot and might have changed meanwhile.
Reviews by other members of the community are marked by * in the last column.

0 1
0 218

Hi Developers!

In August, you posted 77 new questions on Developer Community:

Questions

20 Questions to Make Meaningful Connections | Inc.com

And now it's time to announce the Key Questions of August chosen by InterSystems Experts!

1 0
0 269

Hi Developers!

With the clear and crisp autumn climate, we are pleased to announce the launch of the
🏆 1st Tech Article Contest on Chinese Developer Community🏆.

From September 5 to October 24, 2022 (Beijing Time), we welcome you to contribute articles related to InterSystems technology.

🎁 Prizes for Everyone: A special prize pack for each author who takes part in the contest.

🏆 Main Prizes: Apple iPad; Beats Fit Pro; HUAWEI WATCH; Logitech ERGO keyboard; WD SSD; KEEP Smart Bracelet

5 0
0 769
Announcement
· Sep 4, 2022
Getting to know FHIR

Hello Developers!

To start our "Back to school on FHIR with DC FR" we propose you to watch this short video about FHIR:

⏯ The Future of Care Begins with InterSystems and FHIR

https://www.youtube.com/embed/HRDKFuG5LcA
[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]

2 1
1 295

Hey Community,

We're excited to announce that Community webinars are back!

Let us invite you all to @sween's webinar on Scaling InterSystems FHIR Server on Amazon Web Services with ECP.

Join this webinar to make a technical deep dive, see a demonstration, and benchmark horizontal scaling InterSystems FHIR Server on Amazon Web Services with Enterprise Cache Protocol (ECP).

⏱ Date & Time: Thursday, August 18, 8 AM ET | 2:00 PM CEST
👨‍🏫 Speaker: @sween, Full Stack Architect at Integration Required

https://www.youtube.com/embed/DBGvt0jd4yI
[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]

3 8
0 790

Hello,

I'm using CircleCI to spin up the image `store/intersystems/irishealth-community:2021.2.0.649.0`.

When building the application we are getting messages that say:

ERROR #5373: Class 'EnsLib.HL7.Message', used by 'Package.Class', does not exist
Skip class Package.Class

Other missing classes seem to include, but not limited to:

Ens.BusinessProcessBPL
Ens.BusinessService
EnsLib.RecordMap.ComplexChild
EnsLib.EDI.XML.Document
Ens.Request

0 19
0 496

InterSystems IRIS for Health ENSDEMO

Yet another basic setup of ENSDEMO content into InterSystems IRIS for Health.

Make sure you have Docker up and running before starting.

Setup

Clone the repository to your desired directory

git clone https://github.com/OneLastTry/irishealth-ensdemo.git

Once the repository is cloned, execute:

Always make sure you are inside the main directory to execute docker-compose commands.

Open Exchange app
5 14
0 594
Article
· Sep 23, 2016 6m read
Creating a RESTful Service using Ensemble

This is a detailed guide to develop RESTful services using InterSystems Ensemble. The goal of this guide is to make you understanding the basic concept and building blocks of a RESTful service. The service is going to provide a very basic functionality (a “Hello world!”).

You will learn how to create required components as Ensemble classes, configure the run-time as an Ensemble Production and create a service configuration as a web application.

5 3
0 2.8K

Hello,

I need to run some clean up routine in the background so loss of my terminal session won't stop the process.

I found the JOB command in the documentation.
JOB | ObjectScript Reference | InterSystems IRIS Data Platform 2022.1

When I try it, it doesn't seem to be doing much. I also expected this to become visible in the Background Tasks but that doesn't happen either.

Probably I am missing something.

1 5
1 527

Hi Community,

We are glad to invite you to the upcoming Interoperability Contest Kick-off Webinar: Building Sustainable Solutions! The topic of this webinar is dedicated to the Interoperability programming contest.

In this webinar, we'll show you some of the general principles and problems of solving sustainability challenges, as well as some great ideas that came up in hackathons for inspiration and do's and don'ts.

Also, we’ll discuss and answer the questions on how to build interoperability solutions using InterSystems IRIS and IRIS for Health.

Date & Time: Monday, August 29 – 09:00 AM EDT

Speakers:
🗣 Tomas Studenik, CEO of Insane Business Ideas and co-founder of Caelestinus
🗣 @Dean Andrews, Head of Developer Relations
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

1 3
0 365

Hi,

I have this arrangement of mirror

Node 1: Primary

Node 2: Failover

Async member is DR server

There is also an arbiter on another server

I want to make 'Node 2' primary as 'Node 1' is to be taken down for some scheduled maintenance work.

I know that I can issue 'iris stop' on 'Node 1' and 'Node 2' should takeover as Primary.

Questions

1. Is this a reliable recommended way? I have had cases in the past when the Failover node did not take over as Primary

0 4
0 271

1. Integrated ML Demonstration

This repository is a demonstration of IntegratedML and Embedded Python.

SideBySidePythonAndCos

Open Exchange app
6 1
3 692
Hello everyone! Don't miss the Developer Community Digest for August 2022!
General Stats
✓ 133 new posts published in August:
– 16 new articles
– 36 new announcements
– 77 new questions
– 4 new discussions
✓ 161 new members joined in August
✓ 10,068 posts published all time
✓ 11,462 members joined all time
0 0
0 112

Hi everyone!

I am recruiting on a fully remote Intersystems Developer. This role will be a long term contract to begin with high likelihood of extensions or conversion permanent. Please check out the job description down below and feel free to send me an email with your resume: Spencer.Frey@insightglobal.com

0 1
0 379

Background

Most websites have a "Fav.ico" file that sets what the icon is for the webpage. Most users have multiple environments, Dev/Test/Live. Often it can be difficult at a glance to see which environment you are in at a time. Wouldn't it be nice to visually see what version you are in? In this example all the instances are called the same and are named "ENSEMBLE". Note that this is certainly IRIS FOR HEALTH as is used on 2022.1

The default Icon is IR

2 1
0 457

Hi,

I have a problem when starting the docker container that the collation is standard US

sample:

docker run --name iris1 -d --publish 1972:1972 --publish 52773:52773 containers.intersystems.com/intersystems/iris-community:2022.1.0.209.0 --check-caps false

After the installation I like to import existing classes and globals but it failed due to an collation error

We usually use DEUW = German3

0 3
0 259

Hello,

I am still trying to figure that Calculated Measure stuff and I hope to learn from you. I have several cubes I am trying to create calculated measures using the Calculated Member Expression.

I have a cube called Cards. There is a measure called count that give total cards count of 15,000. There are two dimensions I am considering. One is the CreditGrade (A, B, C, D, nograde) and the other is the date of the scoredate.(2000-2015).

The CreditGrade dimension has two hierarchies. H1 being the creditnumber and H2 being the CreditGrade (The one I need).

0 2
0 199