This interaction pertains to the Database Adapter -

The modification interaction specifies an SQL batch update statement (INSERT, DELETE or UPDATE), which includes the following information:

  • SQL Statement: The SQL batch update statement that you want to execute. For example, an INSERT INTO or DELETE statement.
  • Pass Through: Whether the batch update statement is passed directly to the Backend Database for processing or processed by the Query Processor.
  • Reuse compiled query: Whether or not the query objects created at previous execution are saved in a cache for reuse.
  • Fail on Zero Affected: Whether or not an error is returned if no rows were affected as a result of the batch update execution.
  • Interaction Parameters: The input parameters to the query in sequential order (as appear in the SQL statement).