Skip to main content
Learning Documentation Community Open Exchange Ideas Portal Global Masters Certification Partner Directory Startup Hub
Search by posts, members, tags
Menu English
  • Posts
    • InterSystems Official
    • Articles
    • Announcements
    • Questions
    • Discussions
    • Tags
  • Events
    • Event Calendar
    • InterSystems Idea-A-Thon
    • Programming Contest
  • Products
    • InterSystems IRIS
    • InterSystems IRIS for Health
    • HealthShare
    • TrakCare
    • Caché
    • Ensemble
    • InterSystems Analytics (DeepSee)
    • InterSystems Text Analytics (iKnow)
  • Jobs
    • Job Opportunity
    • Job Wanted
  • Members
  • About
    • About Us
    • FAQ
    • Feedback
    • Report an Issue
    • Share an Idea
    • Code of Conduct
    • Contact Us
Ask AI
EN
  • EN
  • JP
  • ES
  • PT
  • FR
  • CN
  • Profile page
  • Posts (4)
  • Replies (4)
  • Mentions (0)
  • Official certification & Credly badges (0)
  • Followers (0)
  • Following (0)
All posts
  • All posts (4)
  • Articles (0)
  • Announcements (0)
  • Questions (4)
  • Discussions (0)
Question Peter Monteiro · Aug 2, 2022

Adding multiple rows to a projected SQL table - Persistent Object

Hi

I'm trying to add multiple rows at a time to a SQL table for a persistent object, but I can't seem to get the syntax correct. When I try the below it doesn't work.

INSERT INTO Sample_Table.Accounts (Account, AccountName, Bank) 
VALUES 
('123456', 'AccountNameOne', 'BANK1'),
('654321', 'AccountNameTwo', 'BANK2')

Thanks

Peter

#InterSystems IRIS #SQL
0 1
0 218
Question Peter Monteiro · Feb 18, 2022

Reading the header information from a SOAP outbound adapter call

After invoking a SOAP call in a SOAP Outbound Adapter Operation, how do we get the header information? For example, the HTTP 200 response code.

In SoapUI we can read the header information, but we're trying to view it in Production.

 

#InterSystems IRIS #SOAP
0 3
0 409
Question Peter Monteiro · Feb 9, 2022

Inbound SOAP Service WSDL - incorrect portType name

For our WSDL the portType value is being suffixed with "Soap" at the end.

When i update the the SERVICENAME parameter. in the Service I can update the start of the portType value. Is there a way to prevent the suffix being added?

WSDL segment

#InterSystems IRIS #ObjectScript #SOAP
0 3
0 384
Question Peter Monteiro · Oct 20, 2021

Trace XML objects

When I put a trace on a datastream that is a JSON object, I use the .%ToJSON(). Is there an equivalent to working with XML objects to view in the trace?

#InterSystems IRIS #XML
0 3
0 297
Peter Monteiro
@Peter.Monteiro
Integrations / Applications Developer at Government of Jersey
Follow

User statistics

Posts
4
Replies
4
Likes
1
Applications
0
Badges
0
Followers
0
People reached
1.4K
Accepted answers
2
Analytics dashboard
  • Privacy & Terms
  • Guarantee
  • Section 508
  • Contest Terms
  • Cookies Settings
© 2025 InterSystems Corporation, Cambridge, MA. All rights reserved.