I have created a data-loader script and saved as an idl-file.
Can I start this script with a command from a scrript in the Query tool?
No, there is currently no way to directly execute an IDL-file of Invantive Data Loader in the Invantive Query Tool or Invantive Data Hub.
As an alternative, a framework like:
bulk insert into <TARGETTABLE>
select ...
from <SOURCETABLE>
can be used.
There are currently no plans to add this functionality, since most users directly code their data loads in the Query Tool using synchronize
, create or replace table
and/or bulk insert
.
This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.
Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.
Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.