#Other

Post a job Follow
0 Followers · 487 Posts

Choose the tag if you want to post something which doesn't relate to InterSystems data platforms or services. 

Post a job Follow
New
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 29