#Data Import and Export

Post a job Follow
1 Follower · 123 Posts

This topic unites posts which describe approaches, tools, and solutions to import and export data into InterSystems IRIS and other InterSystems Data platform products: CSV, JSON, SQL, flat files, binary files, globals, streams, etc.

Post a job Follow
Question Mauricio Sthandier · Apr 12

CREATE TABLE from another server query

hi 😊,

i'm able to LOAD DATA in IRIS from a rather complex, say Oracle's, query. It works pretty well but requires a target table created aforehand:

LOAD DATA FROM JDBC CONNECTION SOME_OTHER_SERVER QUERY 'complex query here' INTO TargetTable

is there a way to base such target table on the same query ? 
CREATE FOREIGN TABLE seems to require a column definition which I would prefer to be taken from the query
CREATE TABLE AS SELECT seems to be for local queries and other methods, like Linked Table Wizard or %SYSTEM.SQL.Schema.

#Documentation #Other #Data Import and Export #JDBC #Java #Mapping #SQL
1
0 42
Question Pietro Di Leo · Jul 4, 2025

How to export a project XML file for deploy with Visual Studio Code?

Hello everybody, 

I would like to export project contents using Visual Studio Code, as well as I do with InterSystems Studio.

However, while attempting the export through the InterSystems extension I get the following error:

- There are no folders in the current workspace that code can be exported to.

These are the step to reproduce my error:

  1. Create and save a new VSCode workspace
  2. Open a local directory 
  3. Go to the InterSystems extension
  4. Open "Projects" panel and right-click on the project you want to export
  5. Click on "Export Project Contents"

Anyone can help me solving this issue?

#InterSystems IRIS #Data Import and Export #Studio #VSCode
11
3 467