Page History

...

• Use the following activities to query the database:

  FOR_EACH_SQL_QUERY	Query database using SQL and iterate the results~
  SQL_QUERY	Query database using SQL
  SQL_QUERYTOCSV	Query database using SQL to output CSV file

• Use the following activities to perfom insert, update and delete operations in the database:

  SQL_UPDATE

  Update database using SQL

• Use the following activities to execute an SQL stored procedure in the database:

  SQL_CALL	Execute an SQL stored procedure
  SQL_CALLQRYCSV	Query database using an SQL stored procedure to CSV
  SQL_CALLQUERY	Query database using an SQL stored procedure

• Use the following activities to implement transaction control relating to any database insert, update or delete operations you have performed:

  SQL_COMMIT	Commit a database transaction using SQL
  SQL_ROLLBACK	Rollback a database transaction using SQL

...