The Insert Record into Table command adds new rows of data to a table – the equivalent of writing a specified record/table to a file/database. Although this command temporarily places the record/table into the file/database, the action is not permanent until a COMMIT statement has been executed. Until then, the temporary insertion can be reversed by a ROLLBACK statement.
SQL Application File Name – the internal ECMap name that provides the link to the database containing the record/table into which data is being inserted.
SQL Application File Record – the internal ECMap name for the specific record, or table, (in the file/database specified above) into which data is written or inserted.
SQL Table Name – the database name for the table that corresponds to the internal ECMap file name.