I need a stored procedure where I can execute multiple delete from statements.

This will work to create a stored procedure, but when I add in other delete from, get error invalid sql statements when try to create

CREATE PROCEDURE DeleteSpecimenTwo
(IN Specno VARCHAR(50))
BEGIN
DELETE FROM PCONT WHERE PSPECNO = :Specno;
END;

This doesn't work

CREATE PROCEDURE DeleteSpecimenTwo
(IN Specno VARCHAR(50))
BEGIN
DELETE FROM PCONT WHERE PSPECNO = :Specno;

DELETE FROM PSPEC WHERE PSPECNO = :Specno;
END;

0 1
0 291
InterSystems Developer Community is a community of 23,441 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more
Question
· Mar 3, 2023
? %QUERY Wizard in VSCode ?

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()

I was just not able to do it.
​​​​​​​

3 3
0 265

Hi Friends ,

We have requirement to load data into chache tables from external database (ref data). This process will take 1 min to complete all data load.

Currently I have created Business Service to trigger Business Operation with out bound db adapter to load data into cache tables.

process will be trigger when i restarted business service.

But requirement is , this business service should be triggered from outside ensemble environment i.e , this should expose as REST endpoint and share with the external team.

0 1
0 223

I'm wondering how I would go about adding headers to a csv file which has already been created. I am unfamiliar with ObjectScript.

For example if I were to use R, I would simply write..

test <- read.csv("file/path/example/Extract.csv", header=FALSE)
colnames(test) <- c("A","B","C","D","E")

I do not have embedded Python installed either as I would know how to do it in that also.

How could I mirror this in ObjectScript please?

My current create file method:

0 3
0 311

We're electrified to invite all our clients, partners, developers, and community members to our in-person InterSystems Global Summit 2023!

Our Global Summit user conference is your opportunity to connect with trailblazing product developers, fellow users pushing our technology into new frontiers, and the people whose out-of-box thinking is rocking our universities and board rooms. All in the same space. And registration is now open!

➡️ InterSystems Global Summit 2023

🗓 Dates: June 4-7, 2023

📍 Location: The Diplomat Beach Resort, Hollywood, Florida, USA

5 0
0 1.1K
Question
· Feb 13, 2023
IRIS mirror - arbiter status

Hi,

I have a IRIS mirror set

. all running on SUSE Linux

. each on a separate server

consisting of

Primary

Backup

Arbiter

My arbiter is the ISCagent.

Question

=======

Is there a Linux command showing me the status of the ISCagent as arbiter?

The systemctl service command below shows if the service is running but not if it is acting correctly as an arbiter.

I'm looking for a command like iris list which you can run on the Primary or Backup

===

2 11
2 615

Hey Community,

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

New Videos
№ Video Views
1 Winners of the InterSystems Developer Tools Contest 2023 2196
2 Let InterSystems IRIS Do the Work: Git Source Control & Linting ObjectScript Across Editors 172
3 Introduction to AutoML 77
4 Real-Life Experiences Migrating a Caché Application Portfolio to InterSystems IRIS 68
5 [Webinar] Demo of Deltanji: source control tailored for InterSystems IRIS 65
6 Understanding your InterSystems Login Account & Where to Use It 65
7 Real-World CI/CD: Keep Calm & Build On 59
8 Online Meetup with the winners of InterSystems Developer Tools Contest 51
9 InterSystems Startup Accelerator Pitching Sessions 45
10 iris log viewer 44
11 Plugin Interactive Maps and Visualize Geographic Data to your application 40
12 IRIS Table Audit Demo 27
13 [Webinar] Demo of Deltanji: source control tailored for InterSystems IRIS 26
14 cosUrlShortener Demo 24
15 Using the DX Jetpack for VS Code to explore InterSystems classes 21
16 InterSystems Security Development Lifecycle 15
17 log viewer 15
18 Conduct Class Impact of Change Analysis into InterSystems IRIS 12

0 0
0 141

Hi Friends,

I have created one utility method to check given id exist some reference table or not. If exist the method return1 otherwise 0.

But some times the backed table data will be reload with another process (REST request) , on any point of time. This reload process max it will take 30 seconds.

My Requirement is , the utility method should wait , if table reload is in progress.

Could you give me any suggestion for this issue.

Thanks,

Prashanth

0 7
0 261
Article
· Mar 2, 2023 4m read
Tutorial - Streams in Pieces

This tutorial is a follow on to Working with %Query
It was displaying the content of the input stream chopped in fixed-size chunks.
But often those streams are structured and have well-defined separators (e.g HL7)
So as a side subject of this tutorial, this chapter shows how to break a stream into PIECES.

It is exactly the same idea as the $PIECE() function for strings with some add-ons.

12 1
1 478
Article
· Mar 2, 2023 5m read
Tutorial - Working with %Query #2

My previous article introduced you to SQL based Basic Class Query
where a clever wizard created all the required code for you and your essential
contribution was an SQL statement.

Now we enter the real Custom Class Query that provides more freedom but
requires a deeper understanding of the mechanic behind the scene.
The full code example is again on GitHub

8 1
0 324

Hi Community,

Watch this video to explore common security pitfalls within the industry and how to avoid them when building applications on InterSystems IRIS:

⏯ The OWASP Top 10 & InterSystems IRIS Application Development @ Global Summit 2022

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

0 0
1 381

Hi Developers,

Thank you for spending another great year with us on Global Masters. We hope you enjoy the program!

This is the moment you can share your thoughts about Global Masters. What do you like about it? What you'd like to change?

Time to make your wishes for 2023, because this program is FOR you💫

We will build a roadmap for 2023 based on your answers, and we will continue working hard to make it the best developer gamification program!

➡️ Global Masters Survey 2022 (5 min, 10 questions)

2 1
0 130
Article
· Mar 3, 2023 2m read
Reviews on Open Exchange - #25

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.

I also placed a bunch of Pull Requests on Github when I found a problem I could fix.
Some were accepted and merged, and some were just ignored.
So if you did a major change and expect a changed review just let me know.

2 0
0 139
Announcement
· Feb 14, 2023
Community Roundtable: AI / ML

Hi Community,

We are gathering again for the next Community Roundtable. Many of you asked for a roundtable about AL / ML, and we are delighted to bring such a roundtable to you!

Our invited expert from InterSystems: @Thomas Dyar Product Specialist - Machine Learning.

Join our 60-min discussion, prepare your questions, and use cases! There will be a short demo as well.

UPDATE: the recording is available here.

6 5
0 344

I am new to setting up a mirror environment....

We will have a Arbiter, Two Failover members (A,B), and a Async (DR) member (C). I have the two failover members in sync and are configured for Arbiter Control.

My question is about the Async member, when I initially set it up I pointed it to the mirror on the primary node A.

Is that correct?

0 8
0 343

In article

https://community.intersystems.com/print/518106

Traceback (most recent call last):
File "c:\Users\rochesterd\PythonScripts\fhir_stuff\fhir-client-python-main\fhir-client-python-main\src\client.py", line 57, in <module>
patient0 = Patient.parse_obj(patients_resources.search(
AttributeError: 'NoneType' object has no attribute 'serialize'

0 8
0 294
Article
· Mar 2, 2023 3m read
Quick sample database tutorial

Introduction

This is a simple tutorial on the quickest way I found to create a sample database for any purposes such as testing, making samples for tutorials, etc.

Creating a namespace

  1. Open the terminal
  2. Write the command "D $SYSTEM.SQL.Shell()"
  3. Write "CREATE DATABASE " and the name you want for your namespace.

Now you have a new namespace in a faster way than creating it from the Management Portal - which of course offers way more configuration options.

9 5
1 434

Hello everyone,

As someone who is new to the world of InterSystems technology, I have been looking for the best resources to learn more about it.

I have heard great things about InterSystems technology, particularly its speed and scalability, and I want to make sure I have a solid understanding of it before diving in further. From what I understand, the official InterSystems courses cover a wide range of topics and are taught by experts in the field.

0 3
1 217