Learning Documentation Community Open Exchange Global Masters Certification Partner Directory Ideas Portal
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

Our social networks

  

#SQL

13

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

Week
  • Week
  • Month
  • Year
  • All time
AllTop
Question
Mark OReilly · Jul 15
Create a local copy of a linked table

As foreign tables are behind a paywall (booo); we have a external cache system using the intersystems ODBC driver or usually a .jar CacheDB.jar.

The requirement is :

"Create a copy of the external table once a day to perform comparisons to detect changes"

We could go full code and this is what we will do but trying the following should ideally work

#SQL #InterSystems IRIS for Health #Health Connect
0 4
0 42
Announcement
Celeste Canzano · Jul 16
Reminder: Beta Testers Needed for Our Upcoming InterSystems IRIS SQL Professional Certification Exam

Hello Again,

InterSystems Certification is still looking for people to beta test the InterSystems IRIS SQL Professional Certification exam. This is a great way to earn the certification for free! We have extended the deadline of the beta test to August 31, 2025.

#Certification #SQL #InterSystems IRIS #InterSystems IRIS for Health
2 0
0 10

Trending posts

InterSystems IRIS JSON
Ashok Kumar T
4 52
Advisory for IRISSECURITY in InterSystems IRIS 2025.2
Kevin Xu
2 89
Guidelines for using Generative AI when writing posts on Developer Community
Anastasia Dyubaylo
4 49
Show more (2)
Care Compass - InterSystems IRIS powered RAG AI assistant for Care Managers
Brad Nissenbaum
3 53
Composing an OpenAPI 2.0 specification.
Raef Youssef
0 67

Recently released

PivotToPowerBI
by Peter Steiwer
6218
Interoperability REST API Template
by Andrew Sklyarov
98
intersystems-iris-dev-template
by Evgeny Shvarov
1.7K
Featured
iris-vector-search
by Fan Ji
1.6K

News

Full details

Full details

  • Privacy & Terms
  • Guarantee
  • Section 508
  • Contest Terms
  • Cookies Settings
© 2025 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