Learning Documentation Community Open Exchange Ideas Portal Global Masters Certification Partner Directory Startup Hub
Developer Community
  • Posts
    • InterSystems Official
    • Articles
    • Questions
    • Announcements
    • Discussions
    • Tags
  • Events
    • Tech Article Contest
    • Programming Contest
    • InterSystems Ideas Contest
    • Event Calendar
  • 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

EN

Search by posts, members, tags
Language
EN|
ESPTJPCNFREN
  • All posts
  • InterSystems Official
  • Announcements
  • Articles
  • Questions
  • More...
  • No answer
  • No accepted answer
  • With accepted answer
  • Discussions
  • Videos
  • Jobs
  • Jobs Opportunities
  • Jobs Wanted
  • Global Masters Chat

InterSystems resources

  • Download InterSystems IRIS
  • InterSystems Container Registry
  • Early Access Program
  • Developer Hub
  • Share an idea
  • Become a partner
  • InterSystems IRIS Cloud SQL
  • InterSystems IRIS on AWS
  • InterSystems FHIR Server on AWS
  • InterSystems IRIS on Azure
  • InterSystems IRIS for Health on Azure

Our social networks

  

#SQL

9

SQL is a standard language for storing, manipulating and retrieving data in relational databases.

Week
  • Week
  • Month
  • Year
  • All time
AllTop
Question
Scott Roth · Jan 2
Using /api/atellier/v1 to make REST SQL Calls - Locking it Down

There is a Master Table within IRIS that I am populating from Epic but want to share it with our Enterprise Application Development Team (Web). As a test I was able to use _SYSTEM from postman to execute the following.

#REST API #Security #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS
0 7
0 55
Question
Scott Roth · Jan 2
Defining REST API using iris-rest-api-template - Need guidance

Defining my first REST API within InterSystems using iris-rest-Api-template as a basis and I am seeing if someone could provide me some guidance to see if I can make it work.

#ObjectScript #REST API #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS
0 4
0 45
Question
Victor Paredes · Jan 7
How does Cache handle client-side query timeouts (ODBC / SQL Server linked server)?

Hello,

We are accessing an InterSystems Cacha database from Microsoft SQL Server using a linked server over ODBC (ODBC35). Queries are executed using OPENQUERY.

#ODBC #SQL #Caché
0 4
0 37
Question
Martin Nielsen · Jan 5
IRIS development server data-sync best practices

Current setup:

  • 2x IRIS instances in mirror pair
  • 1x IRIS development server (non-mirror)

Right now we have a script that successfully replaces the database for our IRIS development server with the latest snapshot from IRIS production, this process takes under 1 minute.

#API #Performance #SQL #InterSystems IRIS
0 0
0 21
Question
Scott Roth · Jan 7
Varbinary SQL Type to EnsLib.SQL.Snapshot/%Stream

I have a Photo that is stored as an VARBINARY within MS SQL. I would like to Select the data into a EnsLib.SQL.Snapshot, is that possible? I would take it out of the Snapshot and send it to a %Stream so it can be written out to a file.

#ObjectScript #SQL #Caché #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS
0 0
0 12

Trending posts

Debugging REST APIs using %CSP.Request and %CSP.Response
David Hockenbroch
4 54
Generating JWT without access to system x509 cert/keys
Eduard Lebedyuk
0 27
Reviews on Open Exchange - #61
Robert Cemper
0 26
Show more (2)
Using Postman for testing the OAuth2.0 of the InterSystems FHIR repository - Part2
Kate Lau
0 23
InterSystems Ideas News #26
Irène Mykhailova
0 17

Recently released

IRISFHIRServerLogs
by Ashok Kumar T
10913
DBsizeWatch
by Robert Cemper
147
iris-fhir-template
by Evgeny Shvarov
2.2K275
Featured
iris-vector-search
by Fan Ji
1.9K

News

Go there

  • Privacy & Terms
  • Guarantee
  • Section 508
  • Contest Terms
  • Cookies Settings
© 2026 InterSystems Corporation, Cambridge, MA. All rights reserved.

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up