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 38
Question Mauricio Sthandier · Mar 20, 2025

comparison library with renderers in IRIS, similar to Python's difflib ("Helpers for computing deltas")

Hello there 🙋‍♂️,

I'm looking towards a functionality alike Python's difflib, but made with Intersystems products. I already know could embed Python code within IRIS but thought maybe there was a development already done for handling deltas, with a different approach or extra utils.

Even if I find such a library after comparing both might still go with difflib or any other more suitable. Intend to use it for a cross-environment checklist/check tool.

Please find below a sample of HTML rendering computed and made with difflib, with a few lines of code:

thanks ! best regards,  

#Ensemble #InterSystems IRIS #Global Masters #InterSystems Ideas Portal #InterSystems Reports (Logi) #Open Exchange
0
0 126