Methods of running load queries

You can use these methods to run load queries.
  • Use the Load button on the Load Queries tab. When you run a load query manually, you can add missing columns to a table as well as load data.
  • Use a non-SQL script. For example:
    --<<NON-SQL>> 
    
    ExecuteLoadQuery(string tableName, string queryName, bool clearData); 
  • Use anApplication Engine process with the function ModelingExecuteTableDataLoadQuery For example:
    void ModelingExecuteTableDataLoadQuery(string applicationName, string tableName, string queryName, bool clearData) 
  • Use ION API. For example:
    void ModelingExecuteTableDataLoadQuery(string applicationName, string tableName, string queryName, bool clearData)